Documentation
Getting started
Connect to your first database and run a query in under a minute.
Quick start
-
Install the app
Download DBConnect from the App Store or Google Play. No account or sign-up needed.
-
Add a connection
Tap New Connect, pick your database type, then enter host, port, username, password and (optionally) the database name. Give it a color tag to find it fast later.
-
Test & connect
Use Test to verify credentials, then tap the connection to open its workspace. Your credentials are saved securely on-device only.
-
Explore & query
Browse schemas, tables and objects, or open the SQL editor to run queries with autocomplete. Results appear in a scrollable grid you can export.
Connecting to a database
DBConnect supports 10 database types. Each connects a little differently:
| Database | Default port | Notes |
|---|---|---|
| PostgreSQL | 5432 | SSL modes: disable / require / verify-full |
| MySQL | 3306 | SSL modes: disable / preferred / required |
| MariaDB | 3306 | Use a mysql_native_password user (ed25519 not supported) |
| TiDB | 4000 | Enable SSL for TiDB Cloud instances |
| CockroachDB | 26257 | SCRAM-SHA-256 auth; serverless username is user.cluster-id |
| Amazon Redshift | 5439 | Database password auth (AWS IAM not supported) |
| Oracle | 1521 | Connect by SID or Service Name |
| SQL Server | 1433 | Schema/database context supported |
| MongoDB | 27017 | Connection string or host/port; SRV supported |
| Firebase Firestore | — | Service-account or API-key auth |
Using an SSH tunnel (Premium)
To reach a database that lives behind a bastion / jump host:
- In the connection form, enable SSH Tunnel.
- Enter the SSH host, port, and username.
- Authenticate with a password or a private key (with optional passphrase).
- DBConnect opens a secure local port-forward and routes the database connection through it automatically.
Running queries
- Autocomplete suggests tables, columns and keywords as you type.
- Query history keeps your recent queries; Saved queries store the ones you reuse.
- For SELECTs, results show in a grid — tap a row to see the full record.
- INSERT / UPDATE / DELETE / DDL show a rows-affected confirmation.
- MongoDB uses an interactive shell; Firebase uses a document browser instead of SQL.
Working with tables & objects
- Browse tables, views, indexes, procedures, functions and sequences from the object viewer.
- Create and alter tables with the form-based builder — no need to hand-write DDL.
- Manage indexes, and view an ER diagram of relationships (Premium).
Import & export (Premium)
Export query results to CSV, JSON or SQL and share them via the system share sheet. Import CSV / JSON / SQL files to load data into your tables.