Copilot Tools

What are Copilot Tools?

Copilot Tools in DBCode allow you to interact with your databases using simple natural language. Instead of writing complex SQL queries or remembering connection details, you can simply ask questions about your data and get immediate results.

With DBCode’s Copilot Tools integration, you can:

• Find connections - Copilot can discover your available database connections automatically
• Read database schemas - Ask about tables, columns, and relationships without memorizing your schema
• Execute queries - Ask questions about your data in plain English and get SQL executed for you
• Interpret results - Get insights and explanations of query results in natural language

Get Started

Simply use the agent mode in Copilot to enable the tools in your Copilot chat window. Once activated, you can start asking questions about your data in natural language.

Example Prompts

Here are some examples of what you can ask:

• “Show me all customers who made a purchase in the last 30 days in the database named ‘sales_db’ on my PostgreSQL connection”
• “What’s the schema of my users table in the database named ‘sales_db’ on my MariaDB Dev connection?”
• “Calculate the average order value grouped by product category in the database named ‘sales_db’ on my SQL Server connection”
• “Find connections to my PostgreSQL database”