postgresql-table-design
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
114 skills found
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Specialized IDF (Information Display Frame) sub-agent for generating and reviewing CQRS Query Side implementations across Java, TypeScript, and Go.
Designs and implements professional, interactive filtering UX for data tables based on column data types.
Proven patterns for extracting, caching, and processing analytics data from GA4 and GSC using MCP servers.
Automate GitHub issue triage by analyzing reports against the codebase, verifying technical claims, and providing expert-driven responses to resolve invalid issues.
Strategic test data generation, management, and privacy compliance for scalable, secure, and realistic quality engineering workflows.
Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.
Essential guide to llmemory for document storage and search: installation, database setup with pgvector, document ingestion, hybrid/semantic retrieval, and building RAG systems with multi-tenant support.
Writes, executes, and refines SQL queries, from basic selects to complex multi-table joins, aggregations, and subqueries for data retrieval and reporting.
Shopify integration to manage e-commerce data, products, orders, and customer workflows using Membrane CLI.
Automate Excel report generation from CSVs, databases, or data structures using pandas and openpyxl. Supports chart creation, custom styling, template-based workflows, and data analysis.
Expert AWS solution architecture for startups focusing on serverless, scalable, and cost-effective cloud infrastructure with modern DevOps practices and IaC.