database-audit

Audit MySQL and PostgreSQL databases for orphaned records, duplicates, and missing indexes.

Updated Jan 23, 2026

Search Tags:#database #audit #indexes #duplicates #data-quality #referential-integrity #orphan-records

Ready to run

npx skills add https://github.com/VictorSmaniotto/degestao --skill database-audit-victorsmaniotto

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-audit
Source: https://github.com/VictorSmaniotto/degestao/tree/main/.agent/skills/database-audit
Command: npx skills add https://github.com/VictorSmaniotto/degestao --skill database-audit-victorsmaniotto

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Auditoria e análise de bancos de dados para identificar anomalias, inconsistências, registros órfãos, duplicatas, índices faltantes e problemas de integridade referencial. Use para diagnosticar problemas de dados, planejar migrações, gerar relatórios de qualidade de dados, identificar foreign keys quebradas e otimizar a estrutura de tabelas.

Core Features & Use Cases

Auditoria completa de bancos de dados MySQL/PostgreSQL para identificar órfãos, duplicatas e inconsistências de dados.
Geração de relatórios de qualidade de dados e suporte a migrações com recomendações de correções.
Casos de uso: Diagnosticar problemas de integridade de dados, planejar migrações e otimizar estruturas de tabelas com um relatório consolidado.

Quick Start

Execute uma auditoria de banco de dados contra seus bancos MySQL ou PostgreSQL para gerar um relatório consolidado de qualidade de dados.

Frequently Asked Questions about database-audit

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I audit a MySQL or PostgreSQL database for orphaned records and referential integrity problems?▼

To audit a MySQL or PostgreSQL database for orphaned records and referential integrity problems, run an automated database audit to detect broken foreign keys, nulls, and invalid formats. This generates a consolidated report with prioritized remediation suggestions to fix data anomalies.

What is the best way to generate a data quality report for relational database schemas?▼

The best way to generate a data quality report for relational database schemas is to perform a comprehensive database audit. This identifies duplicates, missing indexes, and orphaned rows, producing a consolidated report that diagnoses data problems and provides prioritized remediation suggestions.

Can I detect missing indexes and duplicate records in my PostgreSQL schema automatically?▼

Yes, you can automatically detect missing indexes and duplicate records in your PostgreSQL schema by running a database audit. The audit scans your relational database structure, identifies missing indices and duplicates, and outputs a consolidated data quality report.

When do I need to run a database audit before planning a database migration?▼

You need to run a database audit before planning a database migration to identify data quality issues like orphaned records, duplicates, and broken referential integrity. Resolving these inconsistencies beforehand ensures a clean, optimized table structure for the migration.

How does a database audit identify broken foreign keys and invalid data formats?▼

A database audit identifies broken foreign keys and invalid data formats by systematically scanning relational database schemas for referential integrity problems and anomalies. It flags orphaned rows, nulls, and invalid formats, consolidating these data quality issues into a prioritized remediation report.