Data Sources
Aicser connects directly to your data sources using encrypted connections. Credentials are stored encrypted at rest using Fernet encryption.
Supported databases
| Database | Type | Default Port |
|---|---|---|
| PostgreSQL | Relational | 5432 |
| MySQL | Relational | 3306 |
| SQL Server | Relational | 1433 |
| ClickHouse | Columnar OLAP | 8123 |
| Snowflake | Cloud warehouse | 443 |
| BigQuery | Cloud warehouse | — |
| Redshift | Cloud warehouse | 5439 |
File uploads
- CSV — comma-separated values
- Excel —
.xlsxand.xlsformats
Uploaded files are stored and queryable like any connected database.
Connecting a database
- Go to Data Sources and click Add Data Source
- Select the database type
- Enter connection details (host, port, database name, username, password)
- Click Test Connection — Aicser verifies connectivity before saving
- Click Save
If the connection test fails, no credentials are stored.
Credential security
- All credentials are encrypted at rest using Fernet symmetric encryption
- The encryption key is configured via
ENCRYPTION_KEYin your environment - Credentials are never logged or exposed in API responses
Schema introspection
Once connected, Aicser introspects the database schema — tables, columns, and data types. This schema is used in the query builder and (in EE) to help the AI generate accurate SQL from natural language.