postgresql
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
npx skills add a5c-ai/babysitter --skill postgresql --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 ```sql -- 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 ```sql -- 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
- Capabilities
- Indexing Patterns
- JSONB Operations
- Target Processes
What does the postgresql skill do?
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
How do I install it?
Run `npx skills add a5c-ai/babysitter --skill postgresql --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From a5c-ai/babysitter, a repository with 1,642 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.