Supported Databases
Plumi connects to all major databases and data warehouses:PostgreSQL
Connect to PostgreSQL databases, including Amazon RDS, Azure Database, and Google Cloud SQL.
MySQL
Connect to MySQL and MariaDB databases, including managed cloud instances.
ClickHouse
Connect to ClickHouse for high-performance analytics on large datasets.
BigQuery
Connect to Google BigQuery for serverless data warehouse analytics.
Snowflake
Connect to Snowflake for cloud data platform analytics.
MongoDB
Connect to MongoDB for document database queries.
Adding a Connection
- Navigate to Data Connectors in the sidebar
- Click Add Connection
- Select your database type
- Enter connection details
- Test the connection
- Save
Connection Security
Plumi uses encrypted connections (SSL/TLS) by default. Your credentials are stored securely and never exposed.
Best Practices
- Use read-only credentials when possible
- Restrict IP access to Plumi’s servers
- Rotate credentials regularly
- Use service accounts instead of personal credentials
Connection Pooling
Plumi manages connection pools automatically:- Connections are reused efficiently
- Idle connections are closed after timeout
- Failed connections are retried automatically
Troubleshooting
Connection Refused
- Verify the host and port are correct
- Check firewall rules allow connections from Plumi
- Ensure the database server is running
Authentication Failed
- Verify username and password
- Check the user has access to the specified database
- Ensure the user can connect from remote hosts
SSL/TLS Errors
- Enable SSL on your database server
- Provide the correct CA certificate if required
- Check SSL mode settings