Repolode
Submit
cin12211

cin12211/orca-q

A desktop and web database editor for PostgreSQL, MySQL, MariaDB, Oracle, SQLite and Redis, with an AI query agent.

Open-source alternative to:DBeaverTablePlus

View on GitHubWebsite
Stars
225
Forks
15
Open issues
3
Last commit
2 days ago

What is it?

OrcaQ is a database editor for connecting to, querying, and exploring PostgreSQL, MySQL, MariaDB, Oracle, SQLite, and Redis. It is offered as an Electron desktop app for macOS and Linux, and can also be started locally through npx or Docker as a web app on port 9432.

For SQL databases it provides a schema explorer, a grid view for table data with filtering and inline editing, a raw SQL editor with autocomplete and EXPLAIN analysis, and ERD diagrams. PostgreSQL has the broadest coverage, including role and permission management, instance monitoring, schema diff, and backup and restore. Redis sessions get a key browser, type-aware value inspection, and a command workbench.

The built-in Orca Agent answers natural-language questions about a database and generates SQL. Mutation queries are shown for explicit confirmation before they run.

Key features

  • 01Connects to PostgreSQL, MySQL, MariaDB, Oracle, SQLite and Redis via connection strings or forms.
  • 02Schema explorer with quick query, DDL preview and ERD actions.
  • 03Table grid with pagination, sorting, filters and inline editing.
  • 04Raw SQL editor with multi-statement execution, formatting and EXPLAIN analysis.
  • 05Schema diff generates migration SQL, and backup and restore support export and import.
  • 06Orca Agent generates SQL from natural language and asks for confirmation before changes.

Use cases

  • Inspecting and editing data in a local or remote PostgreSQL database.
  • Comparing schemas across two databases and generating migration SQL.
  • Browsing Redis keys and running commands in a single interface.
  • Exploring an unfamiliar SQLite file on the desktop.

Quick start

  1. 1

    Run without cloning via npx (Node.js 18+), then open localhost:9432

    npx orcaq
  2. 2

    Or run the Docker image and open localhost:9432

    docker run -d --name orcaq --restart unless-stopped -p 9432:9432 cinny09/orcaq:latest

Things to know

  • The desktop app is available for macOS and Linux only; Windows is listed as coming soon.
  • The npx version does not support SQLite file connections.
  • MySQL lacks advanced roles, metrics, and instance insights.

In collections

Databases & SQL tools

Topics

#database#sql#postgresql#mysql#redis#electron#sqlite#ai-assistant#dbms#mariadb

FAQ

What is orca-q?
A desktop and web database editor for PostgreSQL, MySQL, MariaDB, Oracle, SQLite and Redis, with an AI query agent. OrcaQ is a database editor for connecting to, querying, and exploring PostgreSQL, MySQL, MariaDB, Oracle, SQLite, and Redis. It is offered as an Electron desktop app for macOS and Linux, and can also be started locally through npx or Docker as a web app on port 9432.
Is orca-q free to use? What license does it have?
orca-q is open source under the MIT license. Check the license terms before using it in commercial products.
Is orca-q still maintained?
Actively maintained. The last commit to orca-q was on Nov 5, 2026.
What can I use orca-q for?
Inspecting and editing data in a local or remote PostgreSQL database. Comparing schemas across two databases and generating migration SQL. Browsing Redis keys and running commands in a single interface. Exploring an unfamiliar SQLite file on the desktop.
How do I install orca-q?
Run without cloning via npx (Node.js 18+), then open localhost:9432: npx orcaq Or run the Docker image and open localhost:9432: docker run -d --name orcaq --restart unless-stopped -p 9432:9432 cinny09/orcaq:latest
Where can I get orca-q?
The source code and installation instructions are on GitHub: https://github.com/cin12211/orca-q

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects