Maintenance in progress: we are indexing a large batch of new skills. Some pages may load slowly or briefly show no results. Nothing is lost, and everything is back to normal within the hour.
Profile My skills Saved Collections Edit profile Submit a skill

Natural Language Postgres

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

majiayu000 06da98c 2 files · 2.0 KB Updated 567 repo stars
Coding & Dev Tools

File contents

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
  • OPENAI_API_KEY or other LLM provider key

Build

pnpm build

Development

pnpm dev

majiayu000/claude-skill-registry-data/tree/main/data/natural-language-postgres commit 06da98cfab

Browse category

Frequently asked questions

npx skillmds add majiayu000/natural-language-postgres