Skip to main content

​
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

  1. Navigate to Data Connectors in the sidebar
  2. Click Add Connection
  3. Select your database type
  4. Enter connection details
  5. Test the connection
  6. Save

​
Connecting Local Databases

Have a database running on your local machine or private network? Use ngrok to create a secure tunnel that Plumi can connect to.
1

Install ngrok

Download and install ngrok from ngrok.com/download
2

Start the tunnel

Run ngrok to expose your local database port:
# For PostgreSQL (default port 5432)
ngrok tcp 5432

# For MySQL (default port 3306)
ngrok tcp 3306

# For MongoDB (default port 27017)
ngrok tcp 27017
3

Copy the forwarding URL

ngrok will display a URL like:
Forwarding  tcp://0.tcp.ngrok.io:12345 -> localhost:5432
4

Add the connection in Plumi

In Data Connectors, enter:
  • Host: 0.tcp.ngrok.io
  • Port: 12345 (the port from ngrok)
  • Database: your database name
  • Username/Password: your database credentials
This is the easiest way to connect local or private databases to Plumi without configuring firewalls or VPNs.
Free ngrok URLs change each time you restart. For a persistent URL, consider ngrok’s paid plans or use a cloud-hosted database.

​
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