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.
133 skills found
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Command-line toolkit for SQL database management: schema design, query optimization, migrations, and performance debugging for SQLite, PostgreSQL, and MySQL.
Build production-ready, reusable Terraform modules for multi-cloud infrastructure. Includes standardized patterns for AWS, Azure, GCP, and OCI with built-in testing and validation.
Systematic performance engineering: baseline measurement, profiling, bottleneck diagnosis, and evidence-based optimization guidance for high-performance applications.
A multi-paradigm ETL pipeline agent supporting batch and streaming data processing, schema inference, and configurable DAG-based transformations for heterogeneous data sources.
Advanced QE reporting, quality dashboards, and predictive analytics for test metrics, code coverage, and deployment readiness to drive data-informed quality decisions.
PostgreSQL schema and migration expert for Diddit. Manages idempotent SQL files, tables, indexes, and constraints following strict camelCase conventions and transactional safety.
Create professional data visualizations with Python using matplotlib, seaborn, and plotly. Includes chart selection guidance, design principles, accessibility standards, and code patterns for publication-quality figures.
Generate bespoke pixel art SVG illustrations for your documentation, READMEs, and presentations. Perfect for character sprites, chat dialogue visualizations, and custom branding.
Securely manage CI/CD secrets with Vault, AWS Secrets Manager, and environment-specific patterns. Prevent credential leakage, implement rotation, and enforce least-privilege access for pipelines.
Elasticsearch DBA skill for cluster architecture, mapping design, performance tuning, and production operations including ILM, shard strategy, and troubleshooting.
Architects enterprise AI agents from structured specs, generating production-ready code, data flow diagrams, and platform-specific logic for ServiceNow, Salesforce, and Snowflake.