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

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

If the directory is not empty:

git 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)

rm -rf .git
git init

3. Install Dependencies

pnpm install

4. Setup Environment Variables

Create .env with required variables:

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

Build

pnpm build

Development

pnpm dev