ToolsBlog

Text 2 SQL AI for Your Database

Try it free:CSV AISQL Formatter

Table of Contents

  • Going from Text to SQL
  • What SQL did ChatDB write?
  • Creating charts so you can understand the data!

SQL is tough. It's a language that's as powerful as it is meticulous, demanding precision and a deep understanding of complex syntax. We can now go from text to SQL, offloading the effort for querying your database to AI.

This sounds really awesome, but what does it actually look like in action?

User Signups per day

Going from Text to SQL #

At ChatDB, we are big on "eating our own dogfood". We use ChatDB on a daily basis to get insights on our data and app usage. We connected ChatDB to our Supabase instance, and we've been able to ask really interesting questions and get instant insights.

For instance, when we needed to analyze our signups per day, we didn't dive into lines of SQL code. Instead, we simply asked ChatDB:

Show me the breakdown of user signups in the last 60 days with signups by day

User Signups per day

Here's what ChatDB did for us:

  1. Analyze the tables to query — The AI understands which tables and fields to access for the requested data.
  2. Write the SQL to get you the answer — It then generates the SQL query needed to fetch the information.
  3. Query your database and return data in a table — Finally, ChatDB executes the query and presents the data in an easy-to-understand format.

What SQL did ChatDB write? #

Curious about the SQL magic behind the scenes? With a click on the code icon, ChatDB reveals the underlying SQL used to fetch your data.

User Signups per day sql

Creating charts so you can understand the data! #

But it's not just about getting the data; it's about visualizing it in a way that makes sense at a glance. That's why ChatDB doesn't just stop at tables; it gives you charts.

Here's a bar chart that illustrates user signups per day:

User Signups per day bar

And an area chart that shows the trend over the last 60 days:

User Signups per day area

In conclusion, AI's Text 2 SQL capability is more than a convenience; it's a transformation in how we interact with data. With ChatDB, you're not just querying data; you're engaging in a dialogue, where insights are a conversation away.

Try the tools from this post

Free and private: your files stay in your browser.

  • CSV AIGet insights from your CSV files using natural language.
  • SQL FormatterFormat and beautify your SQL statements for better readability.

Related posts

Benchmarking NaturalSQL against State of the Art LLMs

Achieving state of the art results on SQL generation for compound questions.

2024-01-16

Introducing NaturalSQL 6.7B

NaturalSQL, a 6.7B open source LLM finetuned on Text to SQL instructions.

2024-01-15

Reduce SQL pains with AI 2 SQL Tools

Tackling the toughest aspects of SQL doesn't have to be daunting with AI 2 SQL.

2023-11-05

ChatDB

Free, browser-side data tools. No uploads, no accounts.

Data tools

Reader

  • Online CSV Viewer
  • Parquet Viewer & Reader
  • Excel Viewer and Editor
  • SQLite Viewer
  • Gzip CSV Reader
  • CSV Size Analyzer
  • Parquet Schema Reader
  • Parquet Metadata Reader
  • Data Profiler
  • Image Measure
  • Shapefile Viewer
  • GeoJSON Viewer

Editor

  • CSV Viewer and Editor
  • Excel Viewer and Editor
  • Online Excel Editor
  • CSV Splitter
  • Markdown Editor
  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner
  • Audio Clipper
  • Video Trim & Crop Tool

Converter

  • CSV to Gzip Converter
  • CSV to Parquet Converter
  • Excel to CSV Converter
  • Parquet to CSV Converter
  • JSON to Parquet Converter
  • Parquet to JSON Converter
  • CSV Decompressor
  • CSV to JSON Converter
  • CSV to Markdown Table
  • Image Converter
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter

Formatter

  • CSV Encoder
  • SQL Formatter
  • JSON Formatter
  • XML Formatter
  • YAML Formatter
  • Dataset README Generator
  • URL Encoder & Decoder
  • Regex Tester

Compressor

  • CSV Compressor
  • CSV to Gzip Converter
  • CSV Decompressor
  • Image Compressor

AI

  • Parquet AI
  • CSV AI
  • Color Palette Generator
  • Extract Image Colors

GIS

  • Lat/Lng Point Finder
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter
  • Shapefile Viewer
  • GeoJSON Viewer

Image tools

Convert To

  • Convert to JPEG
  • Convert to PNG
  • Convert to WEBP
  • Convert to GIF
  • Convert to BMP
  • Convert to TIFF
  • Convert to ICO
  • Convert to AVIF
  • Convert to FF
  • Convert to HDR
  • Convert to EXR
  • Convert to QOI
  • Convert to TGA
  • Convert to PNM

Edit

  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner

Compress

  • Compress JPG
  • Compress JPEG
  • Compress PNG
  • Compress WEBP
  • Compress GIF

Company

  • All tools
  • Blog
  • Privacy Policy
  • Terms of Service

© 2026 ChatDB. All rights reserved.

v2.4.1