Connect from your Mac
Where each host keeps its connection details, which address and port to use, whether it needs TLS, and how to connect with Inlet or from the command line.
Hosted PostgreSQL
- Connect to Amazon Aurora PostgreSQL from your MacConnect to the cluster endpoint to read and write, or the reader endpoint for read-only work. The cluster must be reachable from your Mac (public endpoint and a security group rule) or through a bastion host.
- Connect to Amazon RDS for PostgreSQL from your MacCopy the endpoint and port from the Connectivity & security tab. Your Mac can reach the instance only if it’s publicly accessible and its security group allows your IP; otherwise go through a bastion host.
- Connect to Azure Database for PostgreSQL from your MacCopy the server name and admin login from the server’s Overview page, add your IP to the firewall rules on the Networking page, and connect on port 5432 with TLS, which the server requires by default.
- Connect to Crunchy Bridge from your MacCopy the connection string from the cluster’s Connection tab. TLS is always required; to check the server, download your team’s certificate and use sslmode=verify-full.
- Connect to DigitalOcean Managed PostgreSQL from your MacThe cluster’s Overview page has a Connection Details section with the host, port 25060, user doadmin and database defaultdb. Add your Mac to the trusted sources and connect with TLS.
- Connect to Google Cloud SQL for PostgreSQL from your MacEither add your IP address to the instance’s authorized networks and connect to its public IP with TLS, or run the Cloud SQL Auth Proxy, which needs no allowlist, and connect to 127.0.0.1.
- Connect to Heroku Postgres from your MacGet the current connection URL with heroku pg:credentials:url (or the Credentials tab) and connect with TLS, which Heroku requires. The credentials can change, so fetch them again when a saved connection stops working.
- Connect to Neon from your MacClick Connect in the Neon Console, pick the branch, database and role, and copy the string. For a GUI client, turn connection pooling off to get the direct host; TLS is always required.
- Connect to Railway Postgres from your MacRailway databases are private by default. Either add Public Access in the service’s Networking settings and use DATABASE_PUBLIC_URL, or run railway connect postgres --tunnel-only and connect to the local tunnel.
- Connect to Render Postgres from your MacUse the database’s external URL, from the Connect menu or its Info page. Render requires TLS on external connections and, by default, accepts them from any IP address with valid credentials.
- Connect to Supabase Postgres from your MacClick Connect at the top of your Supabase project to get the connection string. From a Mac on an IPv4-only network, use the session pooler: port 5432, user postgres.<project-ref>.
Hosted MySQL
- Connect to Amazon RDS for MySQL from your MacCopy the endpoint and port from the Connectivity & security tab and the master user name from Configuration. Your Mac needs a network path: a publicly accessible instance and a security group rule for your IP, or a bastion host.
- Connect to PlanetScale from your MacClick Connect on the database’s dashboard, pick a branch and create a password: you get a host, user name, password and database. TLS is required, and the certificate is signed by a CA your Mac already trusts.
MongoDB
On your Mac
- Connect to Homebrew PostgreSQL from your MacHomebrew’s PostgreSQL listens on localhost port 5432. Its superuser is your macOS user name, not postgres, there’s no password, and the database to connect to is postgres.
- Connect to MySQL in Docker from your MacPublish port 3306 with -p and connect to 127.0.0.1 on that port as root (MYSQL_ROOT_PASSWORD) or the MYSQL_USER you created. Use 127.0.0.1, not localhost, with the mysql client: localhost means the Unix socket.
- Connect to Postgres.app from your MacPostgres.app listens on localhost port 5432. Connect as your macOS user name to the database of the same name, with no password; the first time a new app connects, Postgres.app asks you to allow it.
- Connect to PostgreSQL in Docker from your MacPublish the container’s port 5432 with -p, then connect to localhost on that port as postgres (or POSTGRES_USER) with the POSTGRES_PASSWORD you set. The password only applies the first time the data directory is created.