irsyadjpp

irsyadjpp/postgres-mcp-server

Plugin Claude Code

PostgreSQL MCP server with 40+ tools for database administration, performance monitoring, and Java backend integration.

irsyadjpp/postgres-mcp-server

MCP server Claude CodeCodexCursor

Model Context Protocol (MCP) server for PostgreSQL with 40+ tools for database administration, performance monitoring, and Java backend integration. Runs locally from the @irsyadjpp/postgres-mcp-server npm package. Needs 7 environment variables to run.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion. Use when the database is unresponsive, connections are refused, or queries are stuck waiting.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Analyze and resolve deadlock patterns, lock contention, and transaction management issues. Use when investigating stuck queries, lock timeouts, deadlock errors, or transaction isolation problems.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Analyze and optimize database indexes including duplicate detection, deduplication, foreign key indexes, JSONB GIN indexes, and ORM query coverage. Use when investigating slow queries, high disk usage from indexes, or missing index warnings.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Monitor and optimize PostgreSQL maintenance operations including autovacuum tuning, vacuum progress, huge pages, and WAL management. Use when investigating table bloat, vacuum issues, or system resource optimization.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Optimize JPA/Hibernate/Spring Boot ORM performance including N+1 queries, lazy loading, connection pool tuning, batch operations, and prepared statements. Use when investigating slow Java backend performance, high database load from ORM, or entity mapping issues.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Manage and optimize PostgreSQL table partitioning including partition pruning, time-series partitioning, and partition maintenance. Use when investigating large table performance, time-series data growth, or partition-related issues.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Track and validate database schema migrations including Flyway/Liquibase tracking, schema drift detection, generated columns, and extension management. Use when investigating migration failures, schema drift, or version control issues.

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.