skills.rest
peterquiel
peterquielCOMMUNITY
Explore all skills by this author →
GitHub

database-schema

Extract PostgreSQL table definitions, columns, constraints, and indexes from a local database-schema.sql file.

4|Updated Mar 21, 2026
Search Tags:#sql#grep#data-modeling#postgres#database-schema#ddl#schema-introspection
One-click install
npx skills add https://github.com/peterquiel/claude-ape-setup --skill database-schema-peterquiel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema
Source: https://github.com/peterquiel/claude-ape-setup/tree/main/.claude/skills/database-schema
Command: npx skills add https://github.com/peterquiel/claude-ape-setup --skill database-schema-peterquiel

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL schema discovery often requires manual digging through large SQL files; this Skill provides fast, grep-based access to table structures, columns, constraints, indexes, and relationships on-demand.

Core Features & Use Cases

  • On-demand lookup of table definitions, columns, primary/foreign keys, indexes, and constraints by grepping a local database-schema.sql file.
  • Supports quick integration into ORM mappings, code generation, and database design reviews without embedding the full schema in code.
  • Use Case: When designing a new entity, fetch its full schema details to inform model fields and relationships.

Quick Start

Run a lookup for a given table to fetch its columns, types, keys, and relationships.

Frequently Asked Questions about database-schema

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

FAQPage Schema
How do I get PostgreSQL schema details for table definitions and constraints quickly?▼

Get PostgreSQL schema details by grepping a local database-schema.sql file. This returns precise table definitions, columns, primary and foreign keys, indexes, and constraints on-demand without modifying data.

What is the best way to look up database schema structures for code generation?▼

The best way to look up database schema structures for code generation is grepping a local database-schema.sql file. It provides exact columns, types, and relationships to inform ORM mappings and model fields.

Can I use grep to find specific table columns and indexes in a Postgres schema file?▼

Yes, you can use grep to find specific table columns and indexes in a Postgres schema file. This Skill reads the database-schema.sql file and outputs matching schema artifacts on-demand without embedding the full schema.

Do I need a live database connection to query table definitions and relationships?▼

No, you do not need a live database connection to query table definitions and relationships. This Skill performs schema introspection entirely by grepping a local database-schema.sql file, ensuring you never assume schema structure.

Does this schema lookup approach support constraint discovery for query optimization?▼

Yes, this schema lookup approach supports constraint discovery for query optimization. It greps the local database-schema.sql file to return table constraints, primary and foreign keys, and indexes for your database design tasks.

Related Skills

Explore More Software Engineering Skills→
nicolehaugennicolehaugen

schema-drift-apply

Detect API drift, infer PostgreSQL types, patch schema.sql, and rebuild Docker.

Community
Intermediate
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate
drhaltodrhalto
51

Mako Database

Inspect live database schemas, relationships, policies, and RPCs via MCP tools.

Community
Intermediate