Postgresql

Skill a5c-ai/babysitter/library/specializations/web-development/skills/postgresql

Babysitter enforces obedience on agentic workforces and enables them to manage extremely complex tasks and workflows through deterministic, hallucination-free self-orchestration

Install

npx -y skills add a5c-ai/babysitter --skill postgresql

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.

SKILL.md

1.4 KB, as published. Nobody here has run it

PostgreSQL Skill

Expert assistance for PostgreSQL database design and optimization.

Capabilities

Design optimal schemas
Create performant indexes
Implement full-text search
Work with JSONB data
Optimize query performance
Configure replication

Indexing Patterns

-- B-tree for equality and range
CREATE INDEX idx_users_email ON users(email);

-- GIN for JSONB and arrays
CREATE INDEX idx_posts_tags ON posts USING GIN(tags);

-- Full-text search
CREATE INDEX idx_posts_search ON posts USING GIN(to_tsvector('english', title || ' ' || content));

-- Partial index
CREATE INDEX idx_active_users ON users(created_at) WHERE active = true;

JSONB Operations

-- Query JSONB
SELECT * FROM users WHERE metadata->>'role' = 'admin';

-- Update JSONB
UPDATE users SET metadata = metadata || '{"verified": true}'::jsonb WHERE id = 1;

Target Processes

database-design
performance-optimization
backend-development