First Steps
Get up and running with DB Pro
Once you've installed DB Pro, here's how to get started.
Connecting to Your First Database
- Open DB Pro
- Click the + New button to add a new connection
- Choose your database type (PostgreSQL, MySQL, SQLite, etc.)
- Enter your connection details
Example Connection String
For PostgreSQL:
postgresql://username:password@localhost:5432/mydb
For MySQL:
mysql://username:password@localhost:3306/mydb
Running Your First Query
Once connected, you can start writing queries immediately:
SQL
The results will appear in the results panel below your query.
Keyboard Shortcuts
Here are some essential shortcuts to get you started:
- Cmd/Ctrl + Enter - Execute query
- Cmd/Ctrl + S - Save query
- Cmd/Ctrl + N - New query tab
- Cmd/Ctrl + W - Close current tab
Next Steps
Now that you're set up, explore these features:
- Query History - Access your previous queries from the sidebar
- Table Browser - Browse your database schema visually
- Export - Export query results to CSV, JSON, or Excel