Docs/Connections
Database Connections#
QueryMind supports multiple database types and allows you to manage all your connections in one place.
Supported Databases#
| Database | Port | Features |
|---|---|---|
| MySQL | 3306 | Full SQL, AI queries, ERD |
| PostgreSQL | 5432 | Full SQL, AI queries, ERD |
| MariaDB | 3306 | Full SQL, AI queries, ERD |
| Redis | 6379 | Key browser, data viewer |
Connection Settings#
Basic Settings#
- Name: A friendly name to identify this connection
- Type: Select your database type
- Host: Server address (IP or hostname)
- Port: Database port number
- Username: Database user
- Password: Stored securely in your OS keychain
Database Selection#
For SQL databases (MySQL, PostgreSQL, MariaDB):
- Database: Optionally specify a default database
- You can switch databases after connecting
SSL/TLS#
Enable SSL for secure connections:
- Check "Use SSL" in connection settings
- Required for most cloud database providers
Connection Limits#
Connection limits depend on your subscription plan:
| Plan | Saved Connections | Simultaneous |
|---|---|---|
| Guest | 1 | 1 |
| Free | 3 | 2 |
| Pro | Unlimited | 5 |
| Max | Unlimited | 10 |
SSH Tunnel#
For databases behind a firewall, use SSH tunneling:
- Enable "SSH Tunnel" in connection settings
- Enter SSH server details:
- SSH Host: Jump server address
- SSH Port: Usually 22
- SSH Username: Your SSH user
- Private Key: Path to your SSH key (optional)
Troubleshooting#
Connection Refused#
- Verify the host and port are correct
- Check if the database server is running
- Ensure firewall allows the connection
Authentication Failed#
- Double-check username and password
- Verify user has access from your IP
- Check if SSL is required
Timeout#
- Database may be unreachable
- Try using SSH tunnel for remote servers
- Check network connectivity