SQLAI.ai Blog Archive
Start by topic
This archive collects every SQLAI.ai article in one place, from text-to-SQL walkthroughs to database migration notes. If you are here for a specific workflow, use the topic shortcuts below to jump straight to the most relevant guides, tools, and supporting pages.
Latest post: Simpler RAG approach for text-to-SQL to avoid hallucinations from 2/17/25, 9:24 AM.
Generate SQL with AI
Start here if you want AI to turn ideas into SQL, build joins faster, or help draft DDL and reporting queries.
Improve Accuracy with Schema Context
These guides focus on reducing hallucinations by grounding AI in schema exports, autosuggest, large-schema handling, and RAG.
Validate, Format, Optimize, and Explain
If you already have SQL, these internal links take you straight to the tools for cleanup, debugging, tuning, and understanding.
Database-Specific Workflows
Browse supported engines and practical guides for PostgreSQL, SQL Server, MySQL, Snowflake, BigQuery, and more.
All articles
Every post in reverse chronological order.
- Simpler RAG approach for text-to-SQL to avoid hallucinations
2/17/25, 9:24 AM
- Easily Generate SQL JOIN Queries With AI
1/26/25, 6:01 PM
- Automatically Pre-pick Tables for AI When Working With Large Database Schemas
7/1/24, 9:39 AM
- Enhancing AI Accuracy For SQL Generations Using Retrieval-Augmented Generation
1/30/24, 10:52 AM
- Migrate PostgreSQL Database Using Logical Replication and Close to Zero Downtime
1/24/24, 9:52 AM
- Generator Mode: Tell AI What You Want
12/13/23, 10:17 AM
- SQL Formatter: Free Online SQL Formatter and Highlighter
11/9/23, 10:49 AM
- Use SQL and NoSQL Generators in Multiple Different Languages
3/3/23, 12:24 PM
- Generate Accurate SQL with AI: Case Study
3/2/23, 1:46 PM
- Generate SQL CREATE TABLE Statements with SQL generator
1/3/23, 10:21 AM
- Look up Table and Column Names in Your Custom Database Schema with Autosuggest
12/19/22, 5:08 PM
- SQL Queries to Export Database Schema for SQL Server, MySQL, PostgreSQL, and Oracle
12/10/22, 1:09 PM
- Get the most out of SQL Server Management Studio (SSMS) with AI SQL query generator
12/9/22, 11:31 AM