Glossary · Integration

Database Connection String

A database connection string is a single line of text containing everything needed to connect to a database: the host address, port, database name, username, password, and options like SSL settings.

A connection string like postgresql://user:password@db.example.com:5432/myapp?sslmode=require is the universal key to a database–every client, library, and tool accepts one. Cloud providers like Supabase, Neon, and RDS display it on the dashboard, ready to copy. Two things matter in practice: security (a connection string contains credentials, so it belongs in a secrets manager, never in code or chat logs) and least privilege (the string you hand to an analytics tool should belong to a read-only database user, so the tool physically cannot modify data).

Fig — every answer ships with the tables, rows and SQL behind it.