pg-data

Translate natural language requests into read-only SQL queries for three databases.

230|137|Updated Nov 10, 2025
One-click install
npx skills add https://github.com/tyrchen/geektime-bootcamp-ai --skill pg-data
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pg-data
Source: https://github.com/tyrchen/geektime-bootcamp-ai/tree/main/.claude/skills/pg-data
Command: npx skills add https://github.com/tyrchen/geektime-bootcamp-ai --skill pg-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Generating SQL from natural language helps data teams quickly access insights without risking data integrity. This skill translates user questions into production-ready, read-only queries across blog_small, ecommerce_medium, and saas_crm_large databases, aligning with security policies and schema awareness.

Core Features & Use Cases

  • Natural-language to SQL translation with strict read-only enforcement for safe analytics.
  • Cross-database support: blog_small, ecommerce_medium, and saas_crm_large with schema-aware query generation.
  • Workflow-ready: generates parameterized queries, suggests sensible limits, and respects multi-tenant boundaries.

Quick Start

Describe a natural-language data question such as 'Show me total orders by day from ecommerce_medium' to generate the corresponding SQL.

Frequently Asked Questions about pg-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate SQL from natural language for data analytics?

To generate SQL from natural language for data analytics, you submit a plain-text data question to the skill, which translates it into a safe, read-only SELECT query with appropriate joins and filters against your target database.

What is the safest way to run natural-language SQL queries on production data?

The safest way to run natural-language SQL queries on production data is using a tool that enforces strict read-only constraints and generates parameterized SELECT queries to prevent unauthorized data modifications or injection attacks.

Can I use natural-language SQL generation for multi-tenant database isolation?

Yes, you can use natural-language SQL generation for multi-tenant database isolation because the skill enforces security constraints and respects multi-tenant boundaries when translating user questions into queries.

How do I query an ecommerce database schema using plain English?

You query an ecommerce database schema using plain English by describing your data request, which triggers the skill to read the target database schema and generate a parameterized SQL query with sensible limits.

Does natural-language to SQL translation support multiple database schemas?

Yes, natural-language to SQL translation supports multiple database schemas, specifically providing cross-database support for blog_small, ecommerce_medium, and saas_crm_large with schema-aware query generation.

What are the limitations of natural-language SQL generation for data analytics?

Limitations of natural-language SQL generation include strict read-only enforcement, meaning it cannot perform write operations, and it is restricted to querying only the specific database schemas it is configured to access.