Agent skill

natural-language-postgres

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

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/natural-language-postgres

SKILL.md

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

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results