Service information

Plans

freepaid

Platforms

Requirements

email requiredaccount registration required

Description

Text2SQL.AI is an online service that translates plain English into SQL queries using AI. It also explains SQL queries in plain English. The service is available for free and paid plans on their website. Although email and account registration are required, users can connect their custom database schema for generating complex SQL queries. With monthly visits of around 200,000, the service supports SQL dialects for MySQL, PostgreSQL, Snowflake, BigQuery, and MS SQL Server.

Examples

📝🗄️

Convert Text To Sql

#1
inputs
outputs

UPDATE Employee

SET department_id = (SELECT id FROM Department WHERE name = 'London Office')

WHERE name = 'Joe Lee'

#2
inputs
outputs

UPDATE products

SET discount = 0.1

WHERE id IN (

  SELECT id

  FROM (

    SELECT id, COUNT(*) AS count

    FROM orders

    GROUP BY id

    ORDER BY count DESC

    LIMIT 5

  ) AS top_products

)

💻🔍

Explain Sql Queries

inputs

SELECT product_id, COUNT(*) AS num_orders

FROM orders

GROUP BY product_id

ORDER BY num_orders DESC

LIMIT 10

outputs

The SQL query returns the top 10 products by number of orders.

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

Share this page: