Creating Data Sources

Connect your databases to Datix xAgents so your AI agents can query them.

📊 Supported Databases

Datix xAgents supports all major databases:

🔌 Creating a Data Source

Step 1: Navigate to Data Sources

1. Click "Data Sources" in the sidebar
2. Click "+ New Data Source" button

Step 2: Choose Database Type

Select your database type from the dropdown (PostgreSQL, MySQL, Snowflake, BigQuery, etc.)

Step 3: Enter Connection Details

For PostgreSQL/MySQL:

Host: your-database.example.com
Port: 5432 (PostgreSQL) or 3306 (MySQL)
Database Name: your_database
Username: datix_xagents_user
Password: ••••••••••

For Snowflake:

Account: your-account.snowflakecomputing.com
Warehouse: COMPUTE_WH
Database: ANALYTICS_DB
Schema: PUBLIC
Username: datix_xagents_user
Password: ••••••••••

Step 4: Test Connection

1. Click "Test Connection" button
2. Wait for validation (should take 2-5 seconds)
3. Look for success message: ✅ "Connection successful!"

Step 5: Save

Click "Create Data Source" to save.

🔒 Security Best Practices

Read-Only Access

Create a dedicated read-only database user for Datix xAgents:

PostgreSQL:

-- Create user
CREATE USER datix_xagents_user WITH PASSWORD 'secure_password';

-- Grant read-only access
GRANT CONNECT ON DATABASE your_database TO datix_xagents_user;
GRANT USAGE ON SCHEMA public TO datix_xagents_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datix_xagents_user;

-- Auto-grant on future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public 
GRANT SELECT ON TABLES TO datix_xagents_user;

MySQL:

-- Create user
CREATE USER 'datix_xagents_user'@'%' IDENTIFIED BY 'secure_password';

-- Grant read-only access
GRANT SELECT ON your_database.* TO 'datix_xagents_user'@'%';
FLUSH PRIVILEGES;

🎯 Managing Data Sources

Edit Data Source

1. Go to Data Sources
2. Click on a data source
3. Click "Edit"
4. Update settings
5. Test connection
6. Save changes

Deactivate Data Source

Instead of deleting, deactivate:

1. Edit the data source
2. Toggle "Active" to Off
3. Save

❓ Troubleshooting

🚀 Next Steps

• Set up AI Agents to query your data
• Run your first query
• Configure Column Permissions