Skip to main content
The SQL database integration (PostgreSQL-compatible) allows you to connect a database to your chat room. Once connected, Attlas will be able to read the schema of the authorized tables and formulate read queries to accurately answer your users’ questions.

​
🛠️ How to connect

  1. Go to your Chat Settings > Integrations > SQL Database.
  2. Click Connect and fill in your database details:
    • Name & Description: A friendly name and description to help the AI understand what data is inside.
    • Currency (Optional): The primary currency used for monetary values in your tables, helping the AI format and interpret financial data.
    • Host & Port: Your database server address and port (default is 5432 for PostgreSQL).
    • Database: The name of your database.
    • User & Password: Your database credentials (ideally read-only).
    • SSL Mode: Select require or disable.
  3. Click Test to verify the credentials and see how many tables are found.
  4. Click Save to finish.

​
Fill in the connection details

Click the Connect button to open the form and fill in the following fields:

​
⚙️ Managing your integration

Click Settings on your active SQL Database card to manage the following:
  • Select Tables to Share: You don’t have to share everything. Toggle which specific tables or views the AI is allowed to access.
  • Refresh Schema: If you add or edit columns/tables in your database, click Refresh to sync the changes with the AI.
  • Temporarily Disable: Turn the integration on or off at any time using the toggle switch.
  • Disconnect: Click Disconnect to completely remove the database connection.

​
💡 Best practices for database schema

To help Attlas write accurate queries and perform precise calculations, consider these schema design tips:
  • Use precise column types: If you want the chat to perform calculations, such as sums, averages, or ratios, on numeric data, ensure those columns use a numeric type, such as numeric, decimal, integer, or float. Avoid storing numbers as text, such as varchar or text, as this makes calculations harder and less accurate.
  • Add column comments: Use database comments on your tables and columns. Adding a brief description directly to a column, for example COMMENT ON COLUMN users.status IS 'Active statuses: active, suspended, pending', provides crucial context that guides Attlas in writing the correct SQL queries.

​
🔒 Security best practices

To keep your data safe, we highly recommend:
  • Use a Read-Only User: Create a database user with only SELECT permissions. Attlas does not need write access (INSERT, UPDATE, DELETE).
  • Keep SSL Enabled: We recommend setting sslmode to require to encrypt data in transit.
Last modified on July 2, 2026