mcpField
N
natural-language-postgres

natural-language-postgres

github.com/rebyteai-templateData & databases1760 installsUpdated 19w ago
Repository

About natural-language-postgres

A demo app for asking PostgreSQL questions in plain English and receiving database answers. It uses Next.js and AI SDK and requires a PostgreSQL database plus an LLM provider key.

Key features

  1. 01Plain-English database questions
  2. 02PostgreSQL data access
  3. 03Next.js application
  4. 04AI SDK integration

Use cases

  1. 01Querying a PostgreSQL database with natural language
  2. 02Building a demo with an LLM provider

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/rebyteai-template/rebyte-skills --skill natural-language-postgres

After installing, type/natural-language-postgresin Claude Code to confirm it loaded.

Details

From the project README

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

Comments

Markdown supported