Tag: postgresql
Drizzle ORM Schema and Query Best Practices
This guide details best practices for defining PostgreSQL schemas, including naming conventions, foreign key management, and index creation using Drizzle ORM. It strongly recommends using the explicit db.select() builder API for complex que…
Drizzle ORM Schema and Query Guide
Provides specific guidelines for authoring Drizzle ORM schemas and executing queries within the LobeHub PostgreSQL environment. It enforces the use of the select builder API over the relational API and defines standard naming conventions.
Prisma ORM for Type-Safe Database Interactions
This skill guides the correct implementation of Prisma ORM, ensuring proper type safety and usage of generated clients and enums within a TypeScript environment. It facilitates robust database interactions with PostgreSQL.
Cloud Development Environment Setup and Management
Provides instructions for configuring and running a Next.js development environment including PostgreSQL, Redis, and Google OAuth emulation using Docker. It covers service orchestration, database migrations, and environment variable configu…
PostgreSQL Vacuum Monitoring and Tuning
Monitor and tune PostgreSQL vacuum operations, including autovacuum configuration, progress tracking, and transaction ID wraparound prevention. It provides specific tuning recommendations for high-churn OLTP and large analytical tables.
PostgreSQL Slow Query Diagnosis
Provides a systematic workflow for diagnosing and optimising slow PostgreSQL queries by analysing execution plans, index opportunities, and table statistics. It utilises pgtuner-mcp tools to identify resource-intensive queries and recommend…
PostgreSQL Query Optimization and Rewrite Patterns
This skill provides a structured workflow for analysing PostgreSQL execution plans and applying restructuring patterns to improve query performance. It covers techniques such as converting subqueries to joins, managing CTE materialisation, …
PostgreSQL Performance Baseline Generation
Automates the creation of comprehensive PostgreSQL performance baseline reports for comparing database states before and after configuration or schema changes. It captures health metrics, query workloads, table statistics, and index utilisa…
PostgreSQL Lock Contention Diagnosis
This skill provides a structured workflow for diagnosing PostgreSQL lock contention, including identifying blocking chains, analysing wait events, and resolving deadlocks. It guides the agent through investigating idle-in-transaction sessio…
PostgreSQL I/O Performance Deep-Dive
A structured workflow for investigating PostgreSQL I/O performance, covering buffer pool efficiency, table and index hotspots, and checkpoint performance. It correlates I/O patterns with query workloads to diagnose disk bottlenecks and conf…
PostgreSQL Index Analysis and Optimization
This skill provides a comprehensive workflow for PostgreSQL index optimisation, including identifying unused or duplicate indexes, detecting bloat, and recommending new indexes. It leverages HypoPG for hypothetical index testing to estimate…
PostgreSQL Database Health Check
Performs a comprehensive health assessment of PostgreSQL databases by evaluating connections, cache performance, locks, and configuration settings. It generates a scored report with prioritised recommendations and actionable remediation ste…
PostgreSQL Connection Usage Analysis
This skill enables the analysis of PostgreSQL connection patterns to diagnose leaks, saturation, and idle session overhead. It provides actionable recommendations for connection pooling and configuration optimisation using MCP resources and…
PostgreSQL Configuration Tuning and Optimization
Provides systematic PostgreSQL configuration tuning by analysing hardware profiles, workload types, and current settings to generate hardware-aware ALTER SYSTEM recommendations.
PostgreSQL Table and Index Bloat Analysis
This skill provides a workflow for detecting and remediating table and index bloat in PostgreSQL databases. It identifies fragmentation, dead tuples, and wasted space, recommending specific maintenance actions such as VACUUM, REINDEX, or pg…
Amazon Aurora DSQL Management Skill
Facilitates direct interaction with Amazon Aurora DSQL for schema management, query execution, and database migrations. It supports PostgreSQL-compatible distributed SQL operations, including multi-tenant patterns and IAM-based authenticati…