AI2sql
Converts a natural language text into an SQL query.
AI2sql is a plugin that can convert natural language into SQL queries. By using AI capabilities, this plugin translates complex text into structured database questions without the need for programming knowledge. No more guessing which keywords to use or wondering whether you're making mistakes. AI2sql makes it easy for anyone to interact with databases. This plugin streamlines data retrieval processes and saves time and energy. With AI2sql, you can stop translating and start asking natural language questions to get the answers you need.
How to
Comments (0)
API docs
Learn how to use AI2sql effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "Convert the sentence 'Find all the movies directed by Christopher Nolan' into an SQL query."
-
Prompt 2: "What is the average rating of movies released in the year 2020?"
-
Prompt 3: "Retrieve the names and release dates of all movies from the 'Action' genre."
-
Prompt 4: "Get the total count of movies produced by Marvel Studios."
-
Prompt 5: "List the titles and directors of movies with a rating above 8."
Features and commands
| Feature/Command | Description |
|---|---|
generateSQL | This command allows you to convert a natural language query into an SQL query. You need to provide the input text, table names, and columns for accurate conversion. |
getAzureTables | This command retrieves a list of tables from the connected SQL database. You can use this to get an overview of the available tables. |
getAzureTablesWithColumns | This command provides a list of tables with their respective columns from the connected SQL database. Use this to get a detailed understanding of table structures. |
testMySQLConnection | This command tests the connection to a MySQL database using user credentials, server name, and ai2sql_token. It returns the table names and their columns associated with the ai2sql_token. |
testPostgreSQLConnection | This command tests the connection to a PostgreSQL database using user credentials, server name, and ai2sql_token. It returns the table names and their columns associated with the ai2sql_token. |
testConnection | This command tests the connection to a SQL database using user credentials, server name, and ai2sql_token. It returns the table names and their columns associated with the ai2sql_token. |