PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
Optimizes PostgreSQL databases through expert schema design, query tuning, and advanced feature implementation like indexing and JSONB.
npx claudepluginhub a5c-ai/babysitterThis skill is limited to using the following tools:
README.mdExpert assistance for PostgreSQL database design and optimization.
-- 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;
-- Query JSONB
SELECT * FROM users WHERE metadata->>'role' = 'admin';
-- Update JSONB
UPDATE users SET metadata = metadata || '{"verified": true}'::jsonb WHERE id = 1;
Activates when the user asks about AI prompts, needs prompt templates, wants to search for prompts, or mentions prompts.chat. Use for discovering, retrieving, and improving prompts.
Search, retrieve, and install Agent Skills from the prompts.chat registry using MCP tools. Use when the user asks to find skills, browse skill catalogs, install a skill for Claude, or extend Claude's capabilities with reusable AI agent components.
This skill should be used when the user asks to "create an agent", "add an agent", "write a subagent", "agent frontmatter", "when to use description", "agent examples", "agent tools", "agent colors", "autonomous agent", or needs guidance on agent structure, system prompts, triggering conditions, or agent development best practices for Claude Code plugins.