Databases
Plugin
orca-q
The open source | Next Generation database editor
Plugin Signal81/100Strong
maintained100
capable62
documented100
adopted50
Install
$ npx -y skills add cin12211/orca-q --agent claude-code
Stats
219
Stars
14
Forks
Active
Maintenance
TypeScript
Language
MIT
License
8d ago
Last commit
1y ago
Created
Repo: cin12211/orca-q
What's inside
Skill(19 skills)
/accessibility-expertWCAG 2.1/2.2 compliance, WAI-ARIA implementation, screen reader optimization, keyboard navigation, and accessibility testing expert. Use PROACTIVELY for accessibility violations, ARIA errors, keyboard navigation issues, screen reader compatibility problems, or accessibility/css-expertCSS architecture and styling expert with deep knowledge of modern CSS features, responsive design, CSS-in-JS optimization, performance, accessibility, and design systems. Use PROACTIVELY for CSS layout issues, styling architecture, responsive design problems, CSS-in-JS/database-expertDatabase performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration. Use this skill for queries, indexes, connection pooling, transactions, and database architecture decisions./documentation-expertExpert in documentation structure, cohesion, flow, audience targeting, and information architecture. Use PROACTIVELY for documentation quality issues, content organization, duplication, navigation problems, or readability concerns. Detects documentation anti-patterns and/git-expertGit expert with deep knowledge of merge conflicts, branching strategies, repository recovery, performance optimization, and security patterns. Use PROACTIVELY for any Git workflow issues including complex merge conflicts, history rewriting, collaboration patterns, and repository/graphifyUse for any question about a codebase, its architecture, file relationships, or project content — especially when graphify-out/ exists, where the question should be treated as a graphify query first. Turns any input (code, docs, papers, images, videos) into a persistent
Badges
README
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.
npxdoes 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
| Database | Connection Methods | Core Workflows | Notes |
|---|---|---|---|
| PostgreSQL | String, form | Connection test, raw query, schema browse, advanced admin tools | Broadest feature coverage |
| MySQL | String, form | Connection test, raw query, minimum metadata and table browsing | Advanced roles, metrics, and instance insights remain unsupported |
| MariaDB | String, form | Connection test, raw query, minimum metadata and table browsing | Uses a distinct persisted mariadb type |
| Oracle | String, form | Connection test, raw query, minimum metadata and table browsing | Structured form uses serviceName |
| SQLite | File (desktop only), managed | Connection test, raw query, metadata and table browsing | Local files stay desktop-only; Cloudflare D1 and Turso reuse the SQL family path |
| Redis | String, form | Connection test, key browser, type-aware value inspection, workbench, analysis | SQL-only panels stay hidden for Redis sessions |
| Advanced database-administration features are still intentionally PostgreSQL-first unless a database-specific adapter exists. |
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!
-
Fork the repo and create a new branch:
git checkout -b feat/my-feature -
Follow commit conventions:
feat: ...Add a new featurefix: ...Fix a bugchore: ...Miscellaneous tasksdocs: ...Update documentationrefactor: ...Improve code without changing logic
-
Create a Pull Request:
Clearly describe changes and link to relevant issues (if any). -
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.
File tree
cin12211/orca-qView on GitHub
.agent/
rules/
01-identity.md
02-task-classification.md
03-mode-consulting.md
04-mode-build.md
05-mode-debug.md
06-mode-optimize.md
07-technical-standards.md
08-communication.md
09-checklist.md
10-special-situations.md
module-architecture.md
skills/
accessibility-expert/
SKILL.md
css-expert/
SKILL.md
database-expert/
SKILL.md
documentation-expert/
SKILL.md
git-expert/
SKILL.md
nuxt
pinia
playwright-expert/
SKILL.md
postgres-expert/
SKILL.md
refactoring-expert/
SKILL.md
research-expert/
SKILL.md
rest-api-expert/
SKILL.md
slidev
testing-expert/
SKILL.md
typescript-expert/
SKILL.md
vite-expert/
SKILL.md
vue
vue-best-practices
vue-testing-best-practices
vueuse-functions
workflows/
agent-development.md
request.md
.agents/
rules/
graphify.md
workflows/
graphify.md
.claude/
CLAUDE.md
rules/
01-identity.md
02-task-classification.md
03-mode-consulting.md
04-mode-build.md
05-mode-debug.md
06-mode-optimize.md
07-technical-standards.md
08-communication.md
09-checklist.md
10-special-situations.md
module-architecture.md
settings.json
skills/
accessibility-expert/
SKILL.md
css-expert/
SKILL.md
database-expert/
SKILL.md
documentation-expert/
SKILL.md
git-expert/
SKILL.md
graphify/
.graphify_version
references/
add-watch.md
exports.md
extraction-spec.md
github-and-merge.md
hooks.md
query.md
transcribe.md
update.md
SKILL.md
karpathy-guidelines/
SKILL.md
nuxt
pinia
playwright-expert/
SKILL.md
postgres-expert/
SKILL.md
primary-sidebar/
SKILL.md
refactor/
SKILL.md
refactoring-expert/
SKILL.md
research-expert/
SKILL.md
rest-api-expert/
SKILL.md
settings-flow/
SKILL.md
slidev
testing-expert/
SKILL.md
testing-orcaq/
SKILL.md
typescript-expert/
SKILL.md
vite-expert/
SKILL.md
vue
vue-best-practices
vue-testing-best-practices
vueuse-functions
workflows/
agent-development.md
request.md
.codex/
config.toml
environments/
environment.toml
hooks.json
skills/
graphify/
.graphify_version
references/
add-watch.md
exports.md
extraction-spec.md
github-and-merge.md
hooks.md
query.md
transcribe.md
update.md
SKILL.md
nuxt
pinia
slidev
vue
vue-best-practices
vue-testing-best-practices
vueuse-functions
.dependency-cruiser.js
.dockerignore
.env.example
.github/
agents/
copilot-instructions.md
DEPLOY.md
instructions/
module-architecture.instructions.md
ISSUE_TEMPLATE/
bug_report.md
feature_request.md
skills/
nuxt
vue
vue-best-practices
vue-testing-best-practices
vueuse-functions
workflows/
api-tests.yml
e2e.yml
electron-release.yml
release.yml
unit-tests.yml
.gitignore
.husky/
pre-commit
.mcp.json
.opencode/
opencode.json
plugins/
graphify.js
.prettierignore
.prettierrc
.storybook/
main.ts
preview.ts
.tmp/
.5fbfdeefdeeffffa-00000000.hm
.vscode/
extensions.json
AGENTS.md
app/
app.vue
spa-loading-template.html
assets/
css/
driver-tour.css
json-editor-overrides.css
tailwind.css
v-tree.css
fonts/
alpino/
Alpino-Variable.eot
Alpino-Variable.ttf
Alpino-Variable.woff
Alpino-Variable.woff2
alpino.css
chillax/
Chillax-Variable.eot
Chillax-Variable.ttf
Chillax-Variable.woff
Chillax-Variable.woff2
chillax.css
generalSans/
general-sans.css
GeneralSans-Variable.eot
GeneralSans-Variable.ttf
GeneralSans-Variable.woff
GeneralSans-Variable.woff2
GeneralSans-VariableItalic.eot
GeneralSans-VariableItalic.ttf
GeneralSans-VariableItalic.woff
GeneralSans-VariableItalic.woff2
satoshi/
Satoshi-Variable.eot
Satoshi-Variable.ttf
Satoshi-Variable.woff
Satoshi-Variable.woff2
satoshi.css
global.css
icons/
404.svg
ghost.svg
logo-8-bits.svg
not-found-outline.svg
not-found.svg
logos/
1024x1024.png
128x128.png
128x128@2x.png
16x16.png
256x256.png
32x32.png
512x512.png
64x64.png
icon.icns
icon.ico
icon.png
build/
entitlements.mac.inherit.plist
entitlements.mac.plist
bun.lock
CLAUDE.md
CODE_OF_CONDUCT.md
components/
components.json
base/
base-empty/
BaseEmpty.stories.ts
BaseEmpty.vue
index.ts
base-notice/
BaseNotice.stories.ts
BaseNotice.vue
index.ts
code-editor/
BaseCodeEditor.stories.ts
BaseCodeEditor.vue
constants/
index.ts
sqlKeyWord.ts
extensions/
currentStatementHighlighter.ts
currentStatementLineGutter.ts
cursorSmooth.ts
customAutoCompleteUi.ts
extentions.css
fontSizeTheme.ts
icons-svg.ts
index.ts
minimapFactory.ts
redisCommands.json
redisLanguage.ts
selectionBaseTheme.ts
shortCutExecuteCurrentStatement.ts
shortCutExplainCurrentStatement.ts
shortCutFormatOnSave.ts
shortCutSaveFunction.ts
sqlLinter.ts
states/
index.ts
sqlParserConfig.ts
themes/
ayu/
ayuDark.ts
ayuLight.ts
ayuMirage.ts
index.ts
index.ts
orcaDarkTheme.ts
orcaLightTheme.ts
utils/
diagnostic-lint.ts
formatSql.ts
getCurrentStatement.ts
index.ts
pgKeywordCompletion.ts
sqlErrorDiagnostics.ts
code-highlight-preview/
CodeHighlightPreview.stories.ts
CodeHighlightPreview.vue
index.ts
context-menu/
BaseContextMenu.stories.ts
BaseContextMenu.vue
menuContext.type.ts
data-grid/
BaseDataGrid.stories.ts
BaseDataGrid.vue
components/
AgJsonCellEditor.vue
BaseDataGridCopyContextMenu.vue
BaseDataGridEmptyOverlay.vue
cell-renderers/
DataGridRelationCell.vue
constants/
baseTableTheme.ts
constants.ts
index.ts
docs/
USAGE_GUIDE.md
headers/
DataGridKeyHeader.vue
hooks/
index.ts
useAgGridApi.ts
useDataGridAutoSizing.ts
useDataGridContextMenu.ts
useDataGridSelection.ts
useTableTheme.ts
index.ts
utils/
calculateColumnWidths.ts
cellValueFormatter.ts
dynamicColumns.ts
gridColumnDefs.ts
index.ts
suppressDeleteKeyboardEvent.ts
loading-overlay/
index.ts
LoadingOverlay.stories.ts
LoadingOverlay.vue
migration-screen/
index.ts
MigrationScreen.stories.ts
MigrationScreen.vue
Overview.stories.ts
OverviewShowcase.vue
scramble-text/
index.ts
ScrambleText.stories.ts
ScrambleText.vue
shimmer/
index.ts
Shimmer.vue
tree-folder/
docs/
CSS_VARIABLES_AUDIT.md
CUSTOMIZATION.md
DRAG_DROP_ANALYSIS.md
ENHANCEMENTS.md
EXAMPLES.md
guild.md
PERSISTENCE_EXTENSION.md
README.md
TEST_GUIDE.md
V2_SUMMARY.md
VISUAL_GUIDE.md
FileTree.stories.ts
FileTree.vue
index.ts
plugins/
tree-persistence.ts
PseudomorphismDragItem.vue
README.md
treeManagement.ts
TreeRow.vue
types.ts
typography/
index.ts
Typography.stories.ts
Typography.vue
modules/
agent/
AgentWorkspace.vue
... 1600 moreShowing a partial view of a very large repo.
FAQ
orca-q is a Claude Code plugin with 19 hand-picked skills for databases work, indexed on Flowy. Install it with the command on its page. It includes accessibility-expert, css-expert, database-expert. Its skills do not fire on their own yet. Request auto-invocation to have Flowy route them as you prompt. Free and open source.
- What is orca-q?
- The open source | Next Generation database editor
- How do I install orca-q?
- Run these in Claude Code: npx -y skills add cin12211/orca-q --agent claude-code. Then prompt normally.
- Does orca-q auto-invoke its skills?
- Not yet. It is indexed on Flowy as a plain plugin. Request auto-invocation on its page and Flowy will route its skills for you as you prompt.
- Is orca-q free?
- Yes. Flowy is free and open source, with nothing gated. You can read every skill in full before you install.