xiry.

Development · Web app

Natural Language Postgres

Query a Postgres database with natural language and visualize results.

From the Xiry library · Updated 10 October 2026

Visit natural-language-postgres.vercel.app ↗

Natural Language Postgres is an open-source demo app built with the Vercel AI SDK and Next.js. It converts plain English questions into SQL, runs them against a PostgreSQL database, and visualizes the results as tables or charts. It also generates clause-by-clause explanations of the generated SQL queries.

What it's for

  • Query relational databases using plain English prompts
  • Study an open-source reference implementation of text-to-SQL with the Vercel AI SDK
  • Generate instant data visualizations and charts from database query results
  • Learn SQL syntax by viewing interactive explanations of generated clauses

Features

  • Natural language to SQL conversion
  • Real-time SQL query streaming and execution
  • Clause-by-clause explanations on hover
  • Automatic data visualization with tables and charts
  • One-click deployment to Vercel with GitHub repository template
  • Built-in sample queries for testing

Pricing

Open source. Free and open source; self-host on Vercel with your own OpenAI API key and Postgres database.

Details

Type
Web app
Category
Development
Topic
Developer Tools
Open source
Yes
Platforms
Web, Self-hosted
For
Developers and data analysts building text-to-SQL workflows or AI data apps.
Alternative to
Text2SQL.ai, Vanna.ai, Defog.ai
Tags
postgresql, sql, ai sdk, vercel, text to sql, nextjs

Why it was saved

  • @nicoalbanese10, 6 November 2024: Working reference for building natural-language database querying with the Vercel AI SDK, Next.js and shadcn/ui charts; the app itself is open to try.

Related

  • react-best-practices

    Curated React performance rules and coding-agent skills by Vercel

  • Agentation

    Connects AI coding agents to browser annotations for automated UI reviews

  • claude-office-skills

    Office document creation and editing skills for Claude Code CLI.

  • Domain SDK

    TypeScript SDK for adding and managing custom customer domains across platforms

  • ECC

    Agent harness optimization system with skills, hooks, and configs for coding agents

  • Eight Dev Tools, Zero Fluff — Part 6

    Curated list of eight front-end design and developer utility tools

All 13 in Developer Tools →

Updated