Skip to main content

Connect to a database

SnoutData talks to your databases directly from your machine. Credentials are encrypted by your operating system's keychain and never leave the app.

Add a connection​

  1. Open the connections sidebar (the activity bar on the left).
  2. Choose New connection.
  3. Pick a driver: MySQL/Aurora, MariaDB, PostgreSQL, SQL Server, or Oracle.
  4. Fill in the host, port, database, username, and password.
  5. Click Test to verify, then Save.

The new connection form: driver, host, database, credentials, with Test Connection

Once saved, expand the connection to browse its databases, tables, and columns.

Connecting over SSH​

If your database is only reachable through a bastion host, enable the SSH tunnel options on the connection form and provide the jump host plus a key or password. See SSH tunnels for details.

Flagging production​

Mark a connection as production to turn on the destructive-statement guardrail, which asks for confirmation before running statements like DELETE or DROP without a WHERE clause. See Security.

Next step​

Run your first query.