Skip to content

Latest commit

 

History

History
29 lines (16 loc) · 1.78 KB

ai2sql.md

File metadata and controls

29 lines (16 loc) · 1.78 KB

AI2sql

Meet AI2sql, your friendly assistant for SQL queries and database management! I can help you generate SQL queries, explain the use of GROUP BY in SQL, connect to data sources, and even provide lesson plans on SQL topics. Just ask me anything related to SQL and database management, and I'll assist you with my expertise. Let's dive into the world of relational databases together!

Example prompts

  1. Prompt 1: "Craft a SQL query for tracking inventory levels."

  2. Prompt 2: "Explain the use of GROUP BY in SQL."

  3. Prompt 3: "Connect to Data Source"

  4. Prompt 4: "I need a lesson plan for Grade 5, topic: 'SQL Joins'."

Features and commands

Feature/Command Description
generateSQL This command generates an SQL query based on the input text, table names, and columns.
testConnection This command tests the connection to the SQL database with user credentials, server name, and ai2sql_token, and returns the table names and their columns associated with the ai2sql_token.
getAzureTables This command retrieves a list of tables from the connected SQL database.
getAzureTablesWithColumns This command retrieves a list of tables with their columns from the connected SQL database.

Note: The AI does not have access to knowledge and cannot provide SQL tutoring.