Summary
This is a solid reference for PostgreSQL, MongoDB, and Redis fundamentals. It covers the essentials: schema design patterns, query optimization with EXPLAIN ANALYZE, indexing strategies including partial and covering indexes, and Redis caching patterns like cache-aside and distributed locking. The PostgreSQL section is the strongest with practical examples of CTEs, window functions, and triggers. Use this when you need quick syntax for common database operations or want to compare approaches across different database types. It won't make you a DBA, but it handles the 80% of database work that comes up in typical application development without having to context switch to documentation.
Install to Claude Code
npx -y skills add travisjneuman/.claude --skill database-expert --agent claude-codeInstalls into .claude/skills of the current project.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Files
SKILL.md
Select a file.
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
