Dory Docs
Core Features

Connections

Connections are the starting point for most Dory workflows. A connection defines how Dory reaches a database and what credentials it uses.

What You Can Manage

  • Database type.
  • Host, port, database, username, and password.
  • SSL, SSH Tunnel, and deployment-specific options.
  • Local database file paths for SQLite or DuckDB.
  • Workspace-level organization and naming.

Supported Connection Types

TypeTypical Use
ClickHouseAnalytics, events, monitoring, and operational data
PostgreSQL / NeonProduct and application databases
MySQL / MariaDBBusiness systems and web applications
SQLiteLocal files, demos, and small datasets
DuckDB / MotherDuckLocal analytics and file-based analysis

Create a Connection

  1. Open your workspace.
  2. Choose Add Connection.
  3. Select the database type.
  4. Fill in required settings.
  5. Test the connection.
  6. Open Explorer to confirm schema visibility.

Connection Checklist

  • Use credentials with the least privileges needed.
  • Confirm network access from the Dory runtime.
  • Use SSL when required by the database provider.
  • Use absolute paths for local database files.
  • In Docker, mount local file paths into the container.

Naming Recommendations

Use names that make environment and ownership clear, such as:

  • prod-clickhouse-events
  • staging-postgres-app
  • local-sqlite-demo
  • analytics-duckdb-reports

Saved Queries

Save useful SQL in Dory so analysis can be reused by you or your team.

Monitoring

Use Dory monitoring views to inspect ClickHouse query activity, slow queries, errors, and operational signals.

On this page

ConnectionsWhat You Can ManageSupported Connection TypesCreate a ConnectionConnection ChecklistNaming RecommendationsRelated Pages