Database Setup

SQLsaber supports PostgreSQL, MySQL, SQLite, DuckDB, and CSV data sources. This guide covers all the ways to configure database connections.

Supported Database Types

• PostgreSQL - Full support with SSL
• MySQL - Full support with SSL
• SQLite - Local database files
• DuckDB - Local DuckDB files or in-memory analytics
• CSV - Local CSV files

Adding Database

saber db add my-database

This will prompt you for all necessary connection details.

Connection Strings

SQLsaber supports direct connection strings for PostgreSQL and MySQL, plus file URIs for SQLite and DuckDB.

saber -d "postgresql://user:password@localhost:5432/database"

saber -d "mysql://user:password@localhost:3306/database"

saber -d "duckdb:///path/to/data.duckdb"

Files

SQLite

# Use SQLite file directly
saber -d "./data/sales.db" "Show me total sales by month"

# Relative paths work too
saber -d "~/Documents/mydata.db" "Count all records"

DuckDB

# Query a DuckDB file
saber -d "./warehouse/data.duckdb" "Show the latest partition"

# Use an absolute path
saber -d "duckdb:///Users/me/analytics.duckdb" "Describe orders"

CSV

SQLsaber can also analyze CSV files directly.

saber -d "./customers.csv" "How many customers are from each state?"

Note

For CSV files, first row should contain column headers. SQLsaber will infer data types automatically.

Managing Connections

List All Connections

saber db list

Set Default Database

If you have multiple databases, set one as default:

saber db set-default my-database

Note

By default, SQLsaber will set the first added connection as default.

Test Connections

Verify that a database connection works:

saber db test my-database

Remove Connections

saber db remove my-database

Security

Read-only Access

If you are using SQLsaber with a production database, we recommend setting up a read-only role for your database and using those credentials to setup connection in SQLsaber.

While SQLsaber ensures, via checks before executing queries, that only read queries are executed and in our testing have observed that LLMs follow the system prompt of only generating read queries, there is no guarantee that this is fool-proof.

Tip

If you have a read-replica of your production database, consider using those credentials to setup connection.

In addition to the read-only role, this will provide additional layer of security and ensure no data modifying queries are executed.

Note

For development setups, this isn’t required but is a good practice if you wish to ensure with absolute certainty that no data modifying queries are ever executed.

Password Storage

SQLsaber stores database passwords securely using your operating system’s credentials store.

SSL Certificates

Store SSL certificates in a secure location and use absolute paths when configuring connections.

Troubleshooting

Always test new connections after adding them.

# Test the connection
saber db test my-database

# If connection fails, check the details
saber db list

# Update connection if needed
saber db remove my-database
saber db add my-database  # Start over with correct details

Getting Help

Use the help commands for more information:

saber db --help
saber db add --help

What’s Next?

After setting up your database connections:

1. Configure authentication for AI providers
2. Start querying your data
3. Set up memory for better context
4. Manage conversation threads