Diagnose PostgreSQL databases via REST API health checks.
npx skills add https://github.com/tallclub/matimo --skill postgres-dba
Please help me install this Agent Skill. Skill: postgres-dba Source: https://github.com/tallclub/matimo/tree/main/typescript/examples/mcp/matimo-tools/skills/postgres-dba Command: npx skills add https://github.com/tallclub/matimo --skill postgres-dba
DBAs and platform teams often struggle to quickly diagnose PostgreSQL health issues, identify performance bottlenecks, and plan maintenance across multiple databases and schemas.
Ask me to run a health check on your PostgreSQL database to receive a prioritized diagnostic report.
High-intent search queries and answers about installing and using this skill.
Diagnose slow queries and high dead tuples in PostgreSQL by running automated health checks that analyze slow queries, table bloat, and vacuum status to produce a prioritized diagnostic report.
Yes, you can run a PostgreSQL health check across multiple databases and schemas, executing targeted queries to monitor active connections, index health, and table stats for production deployments.
Automate index health and vacuum status monitoring for PostgreSQL by using guided DBA workflows that query pg_index_health and pg_vacuum_status to identify maintenance needs and performance bottlenecks.
Yes, checking active connections and table bloat requires a REST API wrapper with a POST /query endpoint, using PG_API_URL and PG_API_KEY to authenticate and execute queries against pg_active_connections and pg_table_stats.
Run a PostgreSQL health check for deployment validation, incident response to slow databases, or proactive maintenance planning to detect table bloat, dead tuples, and connection saturation early.
PostgreSQL performance issues may persist beyond slow queries if index health is degraded, table bloat is high, or vacuum status is lagging, requiring a comprehensive diagnostic workflow covering all these areas.
byaan-aiQuery events and analytics via HogQL using the PostHog REST API.
Impertio-StudioDetect table bloat and tune autovacuum settings in PostgreSQL databases.
Chengxufeng1994Analyze SQL execution plans and optimize queries across MySQL, PostgreSQL, SQL Server, and Oracle.
vecearMonitor slow queries, connections, resource usage, and index efficiency in production databases.
