DB Insights Assistant

A Visual Studio Code extension that helps you understand and work with your database more effectively using AI assistance through GitHub Copilot Chat.

Features

• Database Navigation: Easily locate tables and fields in your database

  • Ask questions like "Where can I find table X?"
  • Get quick answers about table locations and relationships

• SQL Query Generation: Get help writing SQL queries

  • Simply describe what data you need in plain English
  • The assistant will generate the appropriate SQL query
  • Example: "Write a query to retrieve all active users from the database"

Installation

1. Open VS Code
2. Go to Extensions (Ctrl+Shift+X)
3. Search for "DB Insights Assistant"
4. Click Install

Requirements

• Visual Studio Code version 1.85.0 or higher
• GitHub Copilot Chat extension
• MS SQL Server extension

How to Use

1. Open GitHub Copilot Chat in VS Code
2. Type @dbinsights in the chat (you'll see it as a suggested option as you type @db)
3. Ask your database-related questions, such as:
   • "Where can I find table X?"
   • "Write a query to retrieve X from the database"
   • "Help me understand the structure of table Y"

Release Notes

1.0.0

Initial release of DB Insights Assistant

Enjoy working with your database!