# Natural Language Postgres

> Chat app that lets you ask questions in plain English and query your PostgreSQL database.

- Skill: `majiayu000/natural-language-postgres` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/natural-language-postgres`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/natural-language-postgres/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/natural-language-postgres

---


# 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

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

If the directory is not empty:

```bash
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)

```bash
rm -rf .git
git init
```

### 3. Install Dependencies

```bash
pnpm install
```

### 4. Setup Environment Variables

Create `.env` with required variables:
- `POSTGRES_URL` - PostgreSQL connection string
- `OPENAI_API_KEY` or other LLM provider key

## Build

```bash
pnpm build
```

## Development

```bash
pnpm dev
```