Postgresql Optimization
This is for when you need PostgreSQL-specific features, not generic SQL. It covers the stuff that makes Postgres different: JSONB operations with GIN indexes, array types and operators, custom enums and composite types, range types with exclusion constraints, and full-text search with tsvector. The examples show actual query patterns for window functions, EXPLAIN ANALYZE workflows, and practical use of extensions like pg_trgm and uuid-ossp. It's focused on optimization and performance tuning rather than basic CRUD. If you're just writing simple queries, you don't need this. If you're leveraging Postgres as more than a MySQL clone, this gives you the advanced data types and indexing strategies that justify using Postgres in the first place.
- GitHub stars
- 298
- last updated
- Jun 11, 2026
Install
$ npx -y skills add syahiidkamil/software-engineer-ai-agent-atlas --skill postgresql-optimization --agent claude-codeInstalls into .claude/skills of the current project.
Files
This is for when you need PostgreSQL-specific features, not generic SQL. It covers the stuff that makes Postgres different: JSONB operations with GIN indexes, array types and operators, custom enums and composite types, range types with exclusion constraints, and full-text search with tsvector. The examples show actual query patterns for window functions, EXPLAIN ANALYZE workflows, and practical use of extensions like pg_trgm and uuid-ossp. It's focused on optimization and performance tuning rather than basic CRUD. If you're just writing simple queries, you don't need this. If you're leveraging Postgres as more than a MySQL clone, this gives you the advanced data types and indexing strategies that justify using Postgres in the first place.
Browse the repository on GitHubSponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/syahiidkamil/software-engineer-ai-agent-atlas
- Categories
- Backend & APIs, AI & Agent Building, Databases
- First seen
- Jun 11, 2026
More from syahiidkamil/software-engineer-ai-agent-atlas
All 17Recommended
More Backend & APIs
claude-apianthropics/skillsReference for the Claude API / Anthropic SDK — model ids, pricing, params, streaming, tool use, MCP, agents, caching, token counting, model migration. TRIGGER —78.9Kskills.sh installs
firebase-firestore-standardfirebase/agent-skillsComprehensive guide for Firestore Standard Edition, including provisioning, security rules, and SDK usage. Use this skill when the user needs help setting up Fi37Kskills.sh installs
gemini-api-devgoogle-gemini/gemini-skillsUse this skill when building applications with Gemini API hosted models, including Gemini and Gemma 4, working with multimodal content (text, images, audio, vid26.7Kskills.sh installs
upstash-redis-jsupstash/skillsWork with the Upstash Redis TypeScript/JavaScript SDK for serverless Redis operations. Use for caching, session storage, rate limiting, leaderboards, full-text 24.5Kskills.sh installs
langchain-middlewarelangchain-ai/langchain-skillsINVOKE THIS SKILL when you need human-in-the-loop approval, custom middleware, or structured output. Covers HumanInTheLoopMiddleware for human approval of dange17Kskills.sh installs