Overview

OrcaQ is a modern database editor for managing, querying, and exploring PostgreSQL, MySQL, MariaDB, Oracle, local and managed SQLite, and Redis data in a fast, intuitive, and secure way.

Installation

Desktop App

The recommended to experience the full capabilities

Download the latest build from GitHub Releases.

Available for: macOS (.dmg, .zip) · Linux (.AppImage, .deb) · Windows comming soon.

NPX

Best for a quick local run without cloning the repo.

npx orcaq

Requires Node.js >= 18. OrcaQ starts on http://localhost:9432.

npx does not support SQLite file connections. Use the desktop app for that workflow.

Local Development

Best for contributing or running the source locally.

git clone https://github.com/cin12211/orca-q.git
cd orcaq
bun install
npm run nuxt:dev

Docker

Best for a clean local deployment without installing Node.js tooling.

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

Open http://localhost:9432.

Supported Databases

Features

Workspace & Connection Management

• Workspaces: Organize related database connections into named workspaces with custom icons, descriptions, and last-opened tracking.
• Connections: Create and manage PostgreSQL, MySQL, MariaDB, Oracle, and SQLite connections using form fields, connection strings, or desktop file-based SQLite setup.
• Security options: Configure SSH tunnels, SSL modes, connection health checks, and environment tags with strict-mode confirmations for sensitive databases.

Exploration & Querying

• Schema Explorer: Browse schemas, tables, views, functions, and sequences from a searchable sidebar with context actions like quick query, rename, DDL preview, and ERD open.
• File Explorer: Manage SQL files and folders in a tree view with nested folders, rename/delete actions, search, and drag-and-drop organization.
• Quick Query: Explore table data in a grid with pagination, sorting, filters, inline editing, bulk actions, related-table previews, query logs, and metadata tabs.
• Raw SQL Editor: Write and run multi-statement SQL with CodeMirror, autocomplete, formatting, variables, EXPLAIN analysis, result tabs, and persisted query files.
• Redis Workspace: Browse keys, inspect string/hash/list/set/zset values, run commands in a workbench, and surface read-only or ACL-limited states clearly.

Database Tools

• ERD Diagram: Visualize a single table or a full schema as an interactive relationship diagram with zoom, pan, searchable table navigation, and FK edges.
• Roles & Permissions: Manage database roles, inheritance, grants, revokes, and bulk permission updates from a visual interface.
• Instance Insights: Monitor PostgreSQL activity, sessions, locks, replication, and configuration from a built-in database health dashboard.
• Schema Diff: Compare two schemas across connections and generate migration SQL with a safe mode that reduces destructive output.
• Backup & Restore: Run native export/import workflows with format options, scope selection, compression, and job progress tracking.
• Family-aware shell: Activity bar items, primary sidebar panels, tabs, and route fallbacks adapt to SQL and Redis families instead of assuming a relational session.

AI & Productivity

• Orca Agent: Ask natural-language questions about your database, generate SQL, inspect schemas, explain queries, detect anomalies, visualize data, export results, and render ERDs.
• Safe AI execution: Mutation queries are not auto-executed; OrcaQ shows the SQL and asks for explicit confirmation before applying changes.
• Command Palette: Jump quickly to tables, views, functions, files, ERDs, tabs, and system actions with keyboard-first search.
• Multi-tab workspace: Open tables, queries, ERDs, admin panels, and agent chats side by side while preserving tab state.

App Experience

• Custom layout system: Use resizable sidebars, multiple panels, saved layout presets, and a status-bar-driven app shell.
• Settings: Configure appearance, code editor behavior, table display, quick query options, AI providers, and environment tags from a unified settings area.
• App data backup: Export and restore workspaces, connections, query files, settings, and AI chat history as app-level backup data.
• Desktop app enhancements: Use SQLite file workflows, in-app updates, recent connections, and multi-window support in the Electron app.

Contributing

We welcome all contributions!

1. Fork the repo and create a new branch:

   git checkout -b feat/my-feature
   

2. Follow commit conventions:

   • feat: ... Add a new feature
   • fix: ... Fix a bug
   • chore: ... Miscellaneous tasks
   • docs: ... Update documentation
   • refactor: ... Improve code without changing logic

3. Create a Pull Request:
   Clearly describe changes and link to relevant issues (if any).

4. Review & Merge:
   The core team will review and provide feedback promptly.

See more: CONTRIBUTING.md

Community / Contact

• Issues: GitHub Issues
• Discussions: GitHub Discussions
• Email: taccin03@gmail.com

License

This project is licensed under the MIT License.

Acknowledgements

• Tauri - Build cross-platform desktop apps with Rust and web technologies
• Vue 3 - Progressive JavaScript framework
• Vite - Next Generation Frontend Tooling
• TypeScript
• Zod - TypeScript-first schema validation
• @vueuse/core - Vue Composition API utilities
• Icon design: Figma Community
• Contributions from the open-source community

Contributors

Many thanks to everyone who has contributed to OrcaQ.

⭐ Stargazers

Many thanks to the kind individuals who leave a star. Your support is much appreciated!

Made with ❤️ by the OrcaQ team and open-source contributors.