# OrcaQ

OrcaQ is an open-source database client and SQL editor that gives developers and homelab owners a local-first workspace for schema design, AI-assisted analysis, and querying PostgreSQL, MySQL, MariaDB, SQLite, Oracle,.

Canonical page: https://ourlocalhost.com/app/8663/orcaq

## Description

OrcaQ is an open-source database client and SQL editor that gives developers and homelab owners a local-first workspace for schema design, AI-assisted analysis, and querying PostgreSQL, MySQL, MariaDB, SQLite, Oracle, Redis, Cloudflare D1, and Turso from desktop, browser, terminal, or Docker environments.

## Platform availability

Available on 3 of 10 platforms: Mac, Linux, Any server.

## Desktop and other devices

Mac, Linux.

## Health score

75/100 (Good), based on 4 of 5 factors.
- Maintained: 100 (last commit 18 days ago)
- Popular: 47 (228 GitHub stars)
- Easy to install: 45 (3 install platforms, install notes)
- Security check: 89 (no serious findings, 1 minor, CI, tests)

## Links

- Official website: https://orca-q.com
- GitHub: https://github.com/cin12211/orca-q
- desktop: https://github.com/cin12211/orca-q/releases/latest
- Documentation: https://orca-q.com/docs

## Common questions

### Which port does a Dockerized OrcaQ instance use?

The documented Docker command publishes container port 9432. You can then reach the app on that host port.

### Can the npx version connect to a local SQLite file?

No, the npx run mode does not support SQLite file connections. Use the desktop app for local SQLite file workflows.

### Are database credentials sent to OrcaQ's cloud when self-hosting?

No, OrcaQ is described as local-first. Your credentials stay on your machine and are never sent to the cloud.

### Can OrcaQ reach a database through an SSH tunnel?

Yes, connection management supports secure access via SSH tunnels. It also supports granular SSL configuration.

### Can I export query results from OrcaQ?

Yes, data export and import supports CSV, JSON, and SQL dump formats.

---
Source: Our Local Host (https://ourlocalhost.com/app/8663/orcaq), the self-hosted and open-source app directory.
