Create a connection

A connection is the credentials ide99 uses to reach a specific PostgreSQL database. Connections are stored locally (passwords go into the system keychain — see Privacy & telemetry).

Open the form

In the empty post-onboarding state, click + Add connection in the center.
From the workspace: + at the top of the left panel, or ⌘+K → Create connection.

Form fields

Field	What to put	Required
Name	Any readable label — shown in the connection list	✓
Host	`localhost`, IP, `db.example.com`	✓
Port	`5432` by default	✓
Database	`postgres` by default	✓
User	Postgres role	✓
Password	Stored in OS keychain, never in a file	—
SSL Mode	`disable / allow / prefer / require / verify-ca / verify-full`. Default `prefer`	✓
Environment	`local / dev / stage / prod` — drives the indicator color and production guards	✓
Read-only	Blocks any `INSERT/UPDATE/DELETE/DDL`. Auto-on for `prod`	—
Confirm destructive	`DROP TABLE`, `TRUNCATE`, `DELETE` without `WHERE` will require typing the table name	—
Slow query warning	If EXPLAIN shows `cost > 100K` — asks before running	—
Exclude from history	Queries against this connection won't be logged into `History`	—

Buttons at the bottom

Test connection — runs SELECT version(). On success, shows the Postgres version with a green tick.
Save without testing — saves without verifying (handy if the DB is temporarily unreachable).
Save — saves and closes the form. The connection appears in the left panel.

Connecting through Docker

If Postgres runs in Docker:

# docker-compose.yml
services:
  pg:
    image: postgres:17-alpine
    ports:
      - "55003:5432"
    environment:
      POSTGRES_PASSWORD: postgres

In ide99 you put:

Host: localhost
Port: 55003 (the port mapped to the outside)
Database: postgres
User: postgres
Password: postgres

Connecting to managed Postgres

Provider	Notes
Supabase	Host like `db.<ref>.supabase.co`, port `5432` or `6543` (pgBouncer). SSL Mode = `require`.
Neon	Host `<endpoint>.neon.tech`, SSL Mode = `require`. SNI supported.
AWS RDS	Endpoint `<id>.<region>.rds.amazonaws.com`. SSL Mode = `require` or `verify-full` with the CA.
GCP Cloud SQL	Cloud SQL Proxy locally — connect to `localhost:5432`. Or public IP + `verify-ca`.

Grouping

In the left panel, connections are sorted by environment (prod on top, colored red). To find one quickly — ⌘+K and start typing the name.

Environments & production guards — how ide99 protects you from accidental DROP TABLE on prod.
SSL and SSH tunnel — for closed corporate networks.