Agent skill · data analytics · manutej
PostgreSQL Database Administration
Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques
Why this skill is useful
Provides advanced database optimization techniques and specific schema designs tailored for customer support systems that the AI wouldn't reliably generate on its own.
What it needs
Requires postgresql installed locally. About 9k tokens when loaded. Last updated 2026-06-13. 61 stars on the source repository.
What this skill does
PostgreSQL Database Administration for Customer Support Overview This comprehensive skill covers PostgreSQL database administration specifically tailored for customer support tech enablement. PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development, known for its reliability, feature robustness, and performance. In customer support environments, PostgreSQL excels at handling complex ticket management, user analytics, audit logging, and real-time reporting requirements. Core Competencies 1. Customer Support Database Design Schema Design Principles When designing databases for customer support systems, focus on: Normalization: Balance between 3NF and denormalization for performance Scalability: Design for growth in ticket volume and user base Auditability: Track all changes with timestamps and user attribution Flexibility: Use JSONB for dynamic metadata and custom fields Performance: Strategic indexing for common query patterns Support Ticket Schema Design Audit Logging Schema 2. Indexing Strategies for Support Queries B-Tree Indexes for Common Queries GIN Indexes for Full-Text Search GIN Indexes for JSONB and Array Operations Partial Indexes for Specific Use Cases 3. Full-Text Search Implementation Basic Full-Text Search Queries Searching Across Multiple Tables 4. Query Optimization for Analytics Window Functions for Ranking and Analytics Materialized Views for Dashboards SLA Tracking Queries 5. Partitioning for Large Support Datasets Range Partitioning by Date List Partitioning by Status or Category 6. Backup and Recovery Procedures Physical Backups with pgbasebackup Logical Backups with pgdump Continuous Archiving Strategy 7. Connection Pooling and Performance Optimization PgBouncer Configuration `ini [databases] supportdb = host=localhost port=5432 dbname=support
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills manutej/postgresql