Docs/Connections

Database Connections#

QueryMind supports multiple database types and allows you to manage all your connections in one place.

Supported Databases#

DatabasePortFeatures
MySQL3306Full SQL, AI queries, ERD
PostgreSQL5432Full SQL, AI queries, ERD
MariaDB3306Full SQL, AI queries, ERD
Redis6379Key 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:

PlanSaved ConnectionsSimultaneous
Guest11
Free32
ProUnlimited5
MaxUnlimited10

SSH Tunnel#

For databases behind a firewall, use SSH tunneling:

  1. Enable "SSH Tunnel" in connection settings
  2. 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

Next Steps#