Connecting a SQL Database

What You'll Learn

Gather the following information from your database administrator:

• •Host: The database server address (e.g., db.example.com)
• •Port: Usually 3306 for MySQL or 5432 for PostgreSQL
• •Database Name: The specific database you want to connect
• •Username & Password: Your database credentials

For enhanced security, create a dedicated read-only user for dataTamer.

For PostgreSQL:

CREATE USER datatamer_readonly WITH PASSWORD 'your_password';
GRANT CONNECT ON DATABASE your_database TO datatamer_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datatamer_readonly;

For MySQL:

CREATE USER 'datatamer_readonly'@'%' IDENTIFIED BY 'your_password';
GRANT SELECT ON your_database.* TO 'datatamer_readonly'@'%';
FLUSH PRIVILEGES;

1. 1. Navigate to Datasources in the left sidebar
2. 2. Click "Add Datasource"
3. 3. Select "SQL Database" (MySQL or PostgreSQL)
4. 4. Click "Continue"

Fill in the database connection form:

• •Database Type: Select MySQL/MariaDB or PostgreSQL
• •Host: Enter your database server address
• •Port: Enter the port (default: 3306 or 5432)
• •Database, Username, Password: Enter your credentials
• •SSL/TLS: Enable if your database requires secure connections

1. 1. Click the "Test Connection" button
2. 2. dataTamer will attempt to connect to your database
3. 3. If successful, you'll see a green checkmark and list of tables
4. 4. If it fails, review the error message and check your credentials

Choose which tables and data to make searchable:

• •Select Tables: Choose specific tables or select all
• •Row Limit: Optionally limit rows for testing
• •Refresh Schedule: Set how often to sync with your database

Once indexing is complete, ask natural language questions like:

• •"Show me all customers who signed up last month"
• •"What's the total revenue by product category?"
• •"Find orders with 'pending' status for more than 7 days"