DBConnect Agent

A Visual Studio Code extension that helps developers query and analyze databases using natural language, powered by LLM.

Features

• Natural Language Queries — Ask database questions in plain English
• Multi-Engine Support — PostgreSQL, MySQL, SQL Server, Oracle
• Schema Inspector — Browse tables, columns, and relationships
• Security Safeguards — Blocks destructive queries unless explicitly confirmed
• LLM-Powered — Uses any OpenAI-compatible API to translate text to SQL

Setup

1. Install Dependencies

npm install

2. Compile

npm run compile

3. Run

Press F5 in VS Code to launch the Extension Development Host, or install the .vsix package.

4. Configure

1. Click the DBConnect Agent icon in the Activity Bar (left sidebar)
2. Click the ⚙️ icon to open Settings
3. Set up your LLM credentials (API URL, API Key, Model)
4. Set up your Database connection (type, host, port, database, credentials)
5. Click Test Connection to verify
6. Click Save

5. Query

Type a natural language question in the input box and press Enter. For example:

• "Show all tables"
• "List employees hired after 2020"
• "Average order value per customer"
• "Generate a quarterly revenue report by region"

Packaging as VSIX

npm install -g @vscode/vsce
vsce package

Then install the .vsix file from VS Code: Extensions → ··· → Install from VSIX.

License

MIT