Advanced SQL helper for PostgreSQL schema design and high-performance query optimization.
Install
mkdir -p .claude/skills/postgresql-ssrjkk && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/19122" && unzip -o skill.zip -d .claude/skills/postgresql-ssrjkk && rm skill.zipInstalls to .claude/skills/postgresql-ssrjkk
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Models relational data, writes optimized queries, and manages PostgreSQL databases with indexes, views, and CTEs. Use for robust data storage.Key capabilities
- →Create tables with `SERIAL PRIMARY KEY` and `NOT NULL` constraints
- →Add unique constraints to columns like email
- →Create indexes on frequently queried columns
- →Write SQL queries with `LEFT JOIN` and `GROUP BY` clauses
- →Filter grouped results using `HAVING` clauses
- →Order query results by aggregate functions
How it works
The skill provides SQL examples for creating tables, indexes, and performing complex queries to manage relational data within a PostgreSQL database.
Inputs & outputs
When to use postgresql
- →Modeling relational data
- →Writing complex SQL joins
- →Creating database indexes
- →Performance tuning queries
About postgresql
Simplifies relational database tasks. It assists in creating schemas, writing complex SQL queries with CTEs, and optimizing performance via indexing strategies.
Models relational data, writes optimized queries, and manages PostgreSQL databases with indexes, views, and CTEs. Use for robust data storage.
When not to use it
- →When unstructured data is being stored
- →When simple key-value storage is sufficient
- →When complex transactional workloads are not a requirement
Prerequisites
Limitations
- →Requires PostgreSQL to be installed
- →Focuses on relational data structures
- →Does not cover NoSQL database patterns
How it compares
This workflow focuses on specific PostgreSQL features like `SERIAL PRIMARY KEY`, `CREATE INDEX`, and advanced SQL constructs, which are tailored for reliable relational data management compared to generic database operations.
Compared to similar skills
postgresql side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| postgresql (this skill) | 0 | 1mo | Review | Beginner |
| sql-optimization-patterns | 64 | 3mo | No flags | Advanced |
| drizzle-orm | 32 | 3mo | No flags | Intermediate |
| postgres-patterns | 20 | 6mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by ssrjkk
View all by ssrjkk →You might also like
sql-optimization-patterns
wshobson
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
postgres-patterns
affaan-m
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
postgresql-table-design
wshobson
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
hybrid-search-implementation
wshobson
Combine vector and keyword search for improved retrieval. Use when implementing RAG systems, building search engines, or when neither approach alone provides sufficient recall.
event-store-design
wshobson
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.