Technology

What is Text to SQL?

Sanmit Vartak

1 min read··Updated

Quick answer

Text to SQL is AI that converts a question written in plain language, such as "Show me sales by region last quarter", into a SQL query, runs it on your database and returns the result. It is also called NL to SQL or NL2SQL.

Text to SQL (also called NL to SQL or NL2SQL) is AI that translates a question written in everyday language into a SQL query for a specific database, runs it and returns the answer as a number, table or chart. It lets people who do not write SQL get answers from business data without waiting for an analyst.

For how it works step by step, how accurate it is on real business data, where it fails and how to choose a tool, read our full guide to NL to SQL.

Ready to act on your data?

See how teams use FireAI to ask in plain language and get analytics they can trust.

Explore FireAI workflows

Go from this topic into product features and solution paths that match what you read here.

Topic hub

AI Analytics

Guides on natural language querying, AI-powered analytics, forecasting, anomaly detection, and automated insights.

Explore hub

Frequently asked questions

What is text to SQL?

Text to SQL is AI that converts a plain-language question into a SQL query, runs it on a database and returns the result, so non-technical users can get data without writing code.

Is text to SQL the same as NL to SQL?

Yes. Text to SQL, NL to SQL and NL2SQL all describe the same task of translating natural language into SQL.

Related in this topic

From the blog