---

name: natural-language-postgres description: Chat app that lets you ask questions in plain English and query your PostgreSQL database.

Natural Language Postgres

A demo app that lets you ask questions in plain English and get answers from your database.

Tech Stack

• Framework: Next.js
• AI: AI SDK
• Database: PostgreSQL
• Package Manager: pnpm

Prerequisites

• PostgreSQL database
• OpenAI API key or other LLM provider

Setup

1. Clone the Template

Copygit clone --depth 1 https://github.com/Eng0AI/natural-language-postgres.git .

If the directory is not empty:

Copygit clone --depth 1 https://github.com/Eng0AI/natural-language-postgres.git _temp_template
mv _temp_template/* _temp_template/.* . 2>/dev/null || true
rm -rf _temp_template

2. Remove Git History (Optional)

Copyrm -rf .git
git init

3. Install Dependencies

Copypnpm install

4. Setup Environment Variables

Create .env with required variables:

• POSTGRES_URL - PostgreSQL connection string
• OPENAI_API_KEY or other LLM provider key

Build

Copypnpm build

Development

Copypnpm dev