Database Reviewer
Analyzes database schemas, identifies inefficiencies, and suggests improvements for performance and data integrity.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add database-reviewer npx -- -y @trustedskills/database-reviewer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"database-reviewer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/database-reviewer"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The database-reviewer skill analyzes a provided database schema and data, identifying potential issues like missing indexes, inefficient queries, or data inconsistencies. It can also suggest improvements to optimize performance and ensure data integrity. This skill helps users understand their database's structure and identify areas for enhancement without requiring deep SQL expertise.
When to use it
- Performance Tuning: Identify slow-running queries and recommend index creation to speed up database operations.
- Schema Validation: Check a new or modified database schema for potential design flaws before deployment.
- Data Quality Assessment: Detect inconsistencies or anomalies within the data stored in a database.
- Learning Database Best Practices: Understand how experienced database administrators approach optimization and maintenance.
Key capabilities
- Database Schema Analysis
- Query Performance Evaluation
- Index Recommendation
- Data Inconsistency Detection
Example prompts
- "Review this SQL schema: [schema definition] and suggest improvements."
- "Analyze the performance of this query: [SQL query] against a database with these tables: [table descriptions]."
- "Check this data for inconsistencies: [sample dataset]"
Tips & gotchas
The skill's effectiveness depends on providing accurate and complete information about the database schema, queries, or data. Large datasets may require significant processing time.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.