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.
107 skills found
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Executes SQL queries against the WordPress development database for inspection, troubleshooting, and audit log analysis.
Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.
Generate optimized SQL queries from natural language. Supports BigQuery, PostgreSQL, MySQL, and Snowflake. Analyze database schemas, interpret business requirements, and output ready-to-run queries with explanations.
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.
Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.
Optimizes Prisma Client connection pool settings for production databases, serverless environments, and high-concurrency architectures to prevent connection exhaustion and performance bottlenecks.
Expert SQL agent for modern database systems, query optimization, HTAP environments, and data architecture patterns. Optimize performance, schema design, and analytical workloads effectively.
Writes, executes, and refines SQL queries, from basic selects to complex multi-table joins, aggregations, and subqueries for data retrieval and reporting.
PostgreSQL schema and migration expert for Diddit. Manages idempotent SQL files, tables, indexes, and constraints following strict camelCase conventions and transactional safety.
Automates the lifecycle management of ephemeral Neon PostgreSQL databases for testing, CI/CD, and rapid prototyping workflows.
Command-line toolkit for SQL database management: schema design, query optimization, migrations, and performance debugging for SQLite, PostgreSQL, and MySQL.