Database Connections
OrcaQ supports multiple database types with a unified connection interface. All credentials are stored locally on your machine for maximum security.
Supported Databases
Native
- PostgreSQL - Full native support
Beta
- MySQL - Beta connector for operational SQL workflows
- MariaDB - Beta connector for MySQL-compatible workflows
- SQLite - Beta connector for local database files
- OracleDB - Beta connector for enterprise database workflows
- Redis - Beta connector for key-value inspection and operational workflows
Coming Soon
- MongoDB
- SQL Server
- Snowflake
Connection Types
Direct Connection
Connect directly to a database server using host, port, and credentials.
text
Host: localhost
Port: 5432
Database: myapp
User: postgres
Password: ••••••••
Connection String
Use a connection string for quick setup:
text
postgresql://user:password@localhost:5432/myapp
SSH Tunnel
Connect through an SSH tunnel for secure remote access:
text
SSH Host: bastion.example.com
SSH User: deploy
SSH Key: ~/.ssh/id_rsa
Database Host: internal-db.local
Security
All connection credentials are:
- Stored locally on your machine
- Encrypted at rest
- Never sent to external servers
- Isolated per workspace
Managing Connections
Edit Connection
- Right-click the connection in the sidebar
- Select Edit Connection
- Update details and save
Test Connection
Click Test Connection before saving to verify your settings are correct.
Remove Connection
Right-click a connection and select Remove to delete it permanently.