Agent-Skills.md

Agent Skills: Natural Language Postgres

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

UncategorizedID: eng0ai/eng0-template-skills/natural-language-postgres

Repository

eng0ai/eng0-template-skills
rebyteai-template
1

Install this agent skill to your local

pnpm dlx add-skill https://github.com/rebyteai-template/rebyte-skills/tree/HEAD/natural-language-postgres

Skill Files

Browse the full folder contents for natural-language-postgres.

Download Skill

Loading file tree…

natural-language-postgres/SKILL.md

Skill Metadata

Name
natural-language-postgres
Description
Chat app that lets you ask questions in plain English and query your PostgreSQL database.

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