Analyzes live PostgreSQL schemas for index gaps, entity drift, and performance issues.
npx skills add https://github.com/zuldare/apuntesIA --skill db-analyzer-zuldare
Please help me install this Agent Skill. Skill: db-analyzer Source: https://github.com/zuldare/apuntesIA/tree/main/skills/db-analyzer Command: npx skills add https://github.com/zuldare/apuntesIA --skill db-analyzer-zuldare
High-intent search queries and answers about installing and using this skill.
Query information_schema.table_constraints for FOREIGN KEY constraints and check pg_indexes for a matching index on the referencing column. This Skill automates that query and ranks severity by table volume, flagging high-traffic tables first.
Compare each @Entity's column names, types, nullable flags, and lengths against information_schema.columns for the actual table. The Skill reports mismatches such as nullable conflicts, length differences, missing columns, and absent FK constraints.
Yes, it connects to the real PostgreSQL database through the MCP postgres server configured in .mcp.json. It runs live queries against information_schema and pg_stat views rather than only reviewing application code.
Use CREATE INDEX CONCURRENTLY to avoid write locks, and ADD COLUMN with a default is safe on PostgreSQL 11+. For foreign keys, add the constraint as NOT VALID and validate it separately to avoid long table rewrites.
Zero-scan indexes may still enforce unique constraints or serve rare batch jobs and reports not exercised in the current environment. The Skill flags them but recommends verifying against production statistics before removal.
RussianRoulette84Apply versioned database migrations to a Postgres MCP server.
AratKruglikDesign Spring Data JPA entities, repositories, and schema migrations for Spring Boot projects.
raylann-lopesSolve JPA/Hibernate N+1 queries and lazy-loading pitfalls in Spring applications.
bikeindexCreate, edit, and evaluate Claude skills with scripts and resources.
