AI2SQL

Convert a SQL statement from one database dialect to another (e.g. MySQL to PostgreSQL, T-SQL to Oracle). Each call is saved to the signed-in user's AI2SQL query history and counts toward their plan allowance. This only adds a history entry: nothing is deleted or overwritten, and the SQL is not run against any database.

convert_sql

List tables and columns of one connected database so SQL can be written against real names. Works for PostgreSQL, MySQL and SQL Server connections; other types return unsupported_dialect. Read-only: it reads table and column names and changes nothing in the database.

describe_schema

Explain what a SQL statement does, step by step, in plain English. Use when the user needs to understand a query they were handed. Each call is saved to the signed-in user's AI2SQL query history and counts toward their plan allowance. This only adds a history entry: nothing is deleted or overwritten, and the SQL is not run against any database.

explain_sql

Repair a failing SQL statement. Pass the SQL and, if available, the error message. Use when the user has a query that errors or returns the wrong shape. Each call is saved to the signed-in user's AI2SQL query history and counts toward their plan allowance. This only adds a history entry: nothing is deleted or overwritten, and the SQL is not run against any database.

fix_sql

Turn a plain-English request into a correct, dialect-aware SQL query. Use when the user describes the data they want and no SQL exists yet. Each call is saved to the signed-in user's AI2SQL query history and counts toward their plan allowance. This only adds a history entry: nothing is deleted or overwritten, and the SQL is not run against any database.

generate_sql

List the databases the user has in AI2SQL (id, name, type). Includes schema-only sample databases (ids like sample-123) that support describe_schema but not run_query. Call this before describe_schema or run_query. Read-only: it reads the user's AI2SQL account and changes nothing.

list_connections

Rewrite a slow query to return the same rows faster and explain the bottleneck. Use when the user says a query is slow. Each call is saved to the signed-in user's AI2SQL query history and counts toward their plan allowance. This only adds a history entry: nothing is deleted or overwritten, and the SQL is not run against any database.

optimize_sql

Run a single SELECT/WITH query against a connected PostgreSQL, MySQL or SQL Server database and return up to 1000 rows. Writes and DDL are rejected. Part of the paid plans. Read-only: nothing in the database is changed.

run_query