Getting Started

Run Employees Database (Optional)

MySQL

docker run -d \                                                                                                         
  --name mysql-employees \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=root \
  -v $PWD/data:/var/lib/mysql \
  genschsa/mysql-employees

Postgres

MsSQL

Create Agent

NOTE: On Catalog page will will see API Keys, Each API keys are tightly coupled with agent.

Export Environments variables

export DS_API_KEY=****
export DB_PASSWORD=root

Register Database Metadata in the Cloud

You can register your database's metadata with Datasherlock. Below is an example configuration for MySQL:

MySQL

type: "mysql"
database:
  host: "127.0.0.1"
  username: "root"
  port: 3306
  database: "employees"
  ssl: false

Postgres

MsSQL

To connect your agent to the Datasherlock cloud, use the following command. It will register your database schema with cloud

sherlock register --config config.yaml -n <AGENT_NAME>

Run an Agent Locally

To run an API server locally on port 8080, use the following command. You can then use this URL to interact with the platform:

sherlock serve --config config.yaml