Database Client
Connect to ten database engines, browse and edit data, and run queries.
Connect
- Run DevSnip Pro: Database Client, or open it from the Database section of the sidebar.
- Click + in the Connections panel.
- Either fill in the Form (type, host, port, user, password, database, TLS) or switch to Connection string and paste a URL —
DATABASE_URL=…lines andjdbc:URLs are accepted. - Press Test connection to see the server version and round-trip time.
- Press Save & connect. The password is stored in your OS keychain.
Connection string examples
| Database | Connection string |
|---|---|
| PostgreSQL | postgresql:/ |
| CockroachDB | cockroachdb:/ |
| MySQL | mysql:/ |
| MariaDB | mariadb:/ |
| SQL Server | Server=localhost,1433;Database=app;User Id=sa;Password=secret;Encrypt=false |
| Oracle | oracle:/ |
| SQLite | sqlite:/ (or Browse…) |
| ClickHouse | clickhouse:/ |
| MongoDB | mongodb:/ or mongodb+srv:/ |
| Redis / Valkey | redis:/ or rediss:/ |
Browse and edit data
- Expand a connection to see its schemas, tables, views, collections or keys.
- The data grid pages, sorts, searches and filters — including MongoDB filters like
{ age: { $gt: 21 } }and Redis patterns likeuser:*. - Edit rows with the type-aware editor (NULL, DEFAULT), MongoDB documents as Extended JSON (
ObjectId(),ISODate()), and every Redis type with TTLs. - Structure shows columns with types, keys and defaults, plus the table’s indexes.
Run queries
- Open a query tab: SQL, T-SQL, PL/SQL, mongosh-style or Redis commands depending on the engine.
- Press Ctrl/Cmd+Enter to run the selection (or the whole editor). Format tidies the query.
- Errors are underlined where the server found them. A long query can be cancelled on the server.
- Sort and filter results, then copy them as JSON or CSV.
Heads upMark a connection Read-only to refuse every write. Destructive statements always ask first, and dropping a table asks you to type its name.