SQL workflows, connections, and ERD tooling in VS Code.

RunQL keeps SQL authoring, execution, schema introspection, and ERD visualization in one workspace flow.

• Run SQL with a dedicated results panel
• Manage and introspect connections (DuckDB, Postgres, MySQL)
• Export query/table results as CSV
• Generate ERD artifacts as JSON you can commit
• Optionally generate docs/comments with AI providers you control

RunQL is offline-first by default. External DB connections and hosted AI providers require network access when used.

• Run active SQL with a keybinding (Shift+Cmd+R on macOS in SQL editors)
• View tabular results in the RunQL: Results panel
• Export CSV and trigger chart generation hooks

• Add/test/select connections and introspect schemas
• Persist schema snapshots as JSON in RunQL/schemas/
• Use introspection for autocomplete and ERD generation

• Generate ERDs for active connections or specific schemas
• Save ERD artifacts under RunQL/system/erd/*.erd.json

• Generate companion Markdown docs and inline SQL comments
• Use VS Code LM API, OpenAI, Anthropic, Azure OpenAI, Ollama, or OpenAI-compatible endpoints
• Keep AI optional; extension works without it

• Search for RunQL in the Extensions view and install.

code --install-extension runql.runql

• Build a platform-specific package and install via:

npm ci
npx vsce package --target darwin-arm64  # use your platform
code --install-extension runql-darwin-arm64-1.2.1.vsix

RunQL initializes a RunQL/ structure for queries, schemas, and system artifacts.

• Create/open a .sql file
• Select a connection
• Run query with Shift+Cmd+R

• Run RunQL: Refresh All Schemas
• Expand the Explorer tree
• Use RunQL: View ERD (Selected Schema) when needed

Common settings (VS Code settings key prefix: runql.):

• runql.query.maxRowsLimit: hard result limit for SELECT queries (0 disables limit)
• runql.ai.provider: none|vscode|openai|anthropic|azureOpenAI|ollama|openaiCompatible
• runql.ai.model: provider-specific model selection
• runql.ai.endpoint: custom endpoint for local/self-hosted providers
• runql.ai.sendSchemaContext: include schema context in AI prompts
• runql.format.enabled: enable SQL formatting

Full reference: docs/configuration.md

• docs/getting-started.md
• docs/features.md
• docs/erd-guide.md
• docs/database-adapters.md
• docs/ai-providers.md
• docs/troubleshooting.md
• docs/security.md

Contributions are welcome. Please read:

• CONTRIBUTING.md
• CODE_OF_CONDUCT.md
• SECURITY.md

This project is licensed under the MIT License. See LICENSE.