Database Connections
Connect clariBI to your existing databases to analyze your data. We support major SQL database systems with secure SSL connections.
Supported Databases
PostgreSQL
Open-source relational database
Full support for PostgreSQL 10+, including JSON columns and advanced data types.
MySQL
Popular open-source database
Compatible with MySQL 5.7+ and MariaDB databases.
SQLite
File-based database
Upload and analyze SQLite database files directly.
SQL Server
Microsoft SQL Server
Connect to Microsoft SQL Server instances for enterprise data analysis.
Oracle
Oracle Database
Connect to Oracle databases for enterprise analytics.
Cloud Data Warehouses
Coming soon - these integrations are currently in development.
BigQuery
Google Cloud
Connect to Google BigQuery for large-scale data analytics.
Snowflake
Cloud Data Platform
Connect to Snowflake for cloud data warehousing.
MongoDB
Document Database
Connect to MongoDB for document-based data analysis.
Setting Up a Connection
Navigate to Data Sources
Go to Settings > Data Sources > Add New
Select Database Type
Choose PostgreSQL, MySQL, SQLite, SQL Server, or Oracle
Enter Connection Details
Provide host, port, database name, and credentials
Test Connection
Click "Test Connection" to verify everything works
Security Recommendations
Best Practices
- Use read-only credentials. Create a database user with SELECT-only permissions.
- Enable SSL. Always use encrypted connections in production.
- Limit table access. Only grant access to tables needed for analysis.
Next Steps
Database Connected?
Now create a dashboard to visualize your data.