Getting Started
Get up and running with DBView in just a few minutes. This guide will walk you through installation, creating your first connection, and running your first query.
Download & Install
Download DBView from our website. The macOS app is signed and notarized by Apple for your security.
Download the latest version
Available for macOS (Apple Silicon & Intel) and Windows
Open the DMG and drag DBView to your Applications folder
Launch DBView from your Applications
Create a Connection
When you first launch DBView, you'll see the connection manager. Click the "New Connection" button to create your first database connection.
MySQL
Host: localhost or your server IP
Port: 3306 (default)
Username: Your MySQL username
Password: Your MySQL password (stored securely in Keychain)
Database: Optional - specify a default database
PostgreSQL
Host: localhost or your server IP
Port: 5432 (default)
Username: Your PostgreSQL username
Password: Your PostgreSQL password
Database: postgres or your database name
SQLite
File Path: Browse to select your .db, .sqlite, or .sqlite3 file
No server required - SQLite databases are local files
SSH Tunnel (Optional)
If your database is behind a firewall or on a remote server, you can connect through an SSH tunnel.
SSH Configuration
SSH Host: Your SSH server hostname or IP
SSH Port: 22 (default)
SSH Username: Your SSH username
Authentication: Password or Private Key (RSA, Ed25519, ECDSA)
Tip: For private key authentication, DBView supports RSA, Ed25519, and ECDSA keys. Keys with passphrases are also supported.
Run Your First Query
Once connected, you can start writing SQL queries in the editor. DBView provides syntax highlighting, auto-completion, and intelligent suggestions.
Execute a query
Use AI Assistant
DBView includes an AI assistant that can help you write SQL queries using natural language. Configure your preferred AI provider in Settings.
Supported AI Providers
OpenAI
GPT-4, GPT-3.5
Anthropic
Claude
Gemini
Ollama
Local models
Go to Settings > AI Settings to configure your API key and preferred model.
