About

Imported from ssrjkk/claude-skills (.claude/skills/database/postgresql/SKILL.md). Install upstream with npx skills add ssrjkk/claude-skills --skill postgresql. Copyright stays with the author.

PostgreSQL

Name: postgresql
Author: ssrjkk

Advanced relational database with powerful querying and indexing.

Quick Start

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_users_email ON users(email);

When to Use

Structured relational data
Complex queries and joins
Transactional workloads
Analytics with window functions

Step-by-Step

Install PostgreSQL
Create database: CREATE DATABASE mydb;
Design schema with migrations
Optimize with EXPLAIN ANALYZE

Dependencies

# psql client
psql -h localhost -U postgres -d mydb

Examples

SELECT u.name, COUNT(o.id) as order_count
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
GROUP BY u.id
HAVING COUNT(o.id) > 5
ORDER BY order_count DESC;

Resources

PostgreSQL Docs

Validation

Connection succeeds
Queries return correct results
Indexes improve query performance

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/ssrjkk-claude-skills-postgresql/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

ssrjkk-claude-skills-postgresql.ocm.jsonjson

{
  "ocm": "1",
  "id": "ssrjkk-claude-skills-postgresql",
  "kind": "skill",
  "name": "postgresql",
  "description": "Models relational data, writes optimized queries, and manages PostgreSQL databases with indexes, views, and CTEs. Use for robust data storage.",
  "publisher": "ssrjkk",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "postgresql",
      "sql",
      "database",
      "relational",
      "queries",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Models relational data, writes optimized queries, and manages PostgreSQL databases with indexes, views, and CTEs. Use for robust data storage."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/ssrjkk/claude-skills",
      "path": ".claude/skills/database/postgresql/SKILL.md",
      "ref": "e1fe9f4b8b62cbb6be06d22940974a7ca87a70b9",
      "url": "https://github.com/ssrjkk/claude-skills/blob/e1fe9f4b8b62cbb6be06d22940974a7ca87a70b9/.claude/skills/database/postgresql/SKILL.md",
      "key": "ssrjkk/claude-skills/.claude/skills/database/postgresql/SKILL.md"
    }
  },
  "instructions": "# PostgreSQL\n\n> Advanced relational database with powerful querying and indexing.\n\n## Quick Start\n```sql\nCREATE TABLE users (\n  id SERIAL PRIMARY KEY,\n  name VARCHAR(100) NOT NULL,\n  email VARCHAR(255) UNIQUE NOT NULL,\n  created_at TIMESTAMP DEFAULT NOW()\n);\n\nCREATE INDEX idx_users_email ON users(email);\n```\n\n## When to Use\n- Structured relational data\n- Complex queries and joins\n- Transactional workloads\n- Analytics with window functions\n\n## Step-by-Step\n1. Install PostgreSQL\n2. Create database: `CREATE DATABASE mydb;`\n3. Design schema with migrations\n4. Optimize with EXPLAIN ANALYZE\n\n## Depe",
  "cost": {
    "context_tokens": 257
  }
}

Fetch it by URL: GET /api/v1/registry/ssrjkk-claude-skills-postgresql/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.