DigitalOcean
Connect a DigitalOcean Managed Database (PostgreSQL, MySQL, or MongoDB) with a connection string over TLS.
Reads data from DigitalOcean Managed Databases: PostgreSQL, MySQL, and MongoDB. Each runs the stock engine, so it connects like a self-hosted database over TLS. Flitch only issues read queries, so it can never write to your database.
Add a source
Pick the tile that matches your engine: DigitalOcean Postgres, DigitalOcean MySQL, or DigitalOcean MongoDB. The connection string in the DigitalOcean control panel (Database → Connection details) carries the host, port, database, and credentials.
Prerequisites
- A DigitalOcean Managed Database cluster.
- A read-only database user, and the connector egress IP in the cluster's Trusted sources.
Create a read-only user
CREATE USER flitch_readonly WITH PASSWORD 'choose-a-strong-password';
GRANT CONNECT ON DATABASE mydb TO flitch_readonly;
GRANT USAGE ON SCHEMA public TO flitch_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO flitch_readonly;Build the connection string
Copy it from the control panel (managed Postgres listens on port 25060 with TLS required):
postgresql://flitch_readonly:password@db-postgresql-xxx.b.db.ondigitalocean.com:25060/mydb?sslmode=requireOpen the form
Go to Data → Add → DigitalOcean Postgres, paste the connection string, then pick datasets.
Create a read-only user
CREATE USER 'flitch_readonly'@'%' IDENTIFIED BY 'choose-a-strong-password';
GRANT SELECT ON mydb.* TO 'flitch_readonly'@'%';
FLUSH PRIVILEGES;Build the connection string
mysql://flitch_readonly:password@db-mysql-xxx.b.db.ondigitalocean.com:25060/mydb?ssl-mode=REQUIREDOpen the form
Go to Data → Add → DigitalOcean MySQL, paste the connection string, then pick datasets.
DigitalOcean MongoDB connects with the MongoDB connection string, so each collection becomes a dataset and documents are flattened into rows.
Copy the connection string
Use the read-only user from the control panel (Database → Connection details):
mongodb+srv://flitch_readonly:password@db-mongodb-xxx.mongo.ondigitalocean.com/mydb?tls=true&authSource=adminOpen the form
Go to Data → Add → DigitalOcean MongoDB, paste the connection string, enter the database name, then pick collections.
Documents map to rows the same way as MongoDB: nested objects become dot-notation columns, arrays are kept as JSON, and columns are inferred by sampling.
Network access
Flitch connects from its own server, not your browser. Add Flitch's connector egress IP (shown in the Add Source form) to the cluster's Trusted sources so the connector can reach it.
Team-wide credential (optional)
A team admin can store one shared credential per engine in Settings → Data connections; new connections then default to it, with no per-connection secret.
Refresh
Refresh is off by default. Enable it to schedule a background refresh and serve from cache between runs. See Refresh.
Troubleshooting
Connection timed out. Add Flitch's egress IP to the cluster's Trusted sources, and keep TLS enabled (managed clusters require it).
Authentication failed. Check the user and password. The MongoDB string often needs authSource=admin.
Wrong port. DigitalOcean managed Postgres and MySQL use port 25060, not the engine default.