db-antipatterns

Detect anti-patterns in relational and NoSQL database schemas.

18|4|Updated Jun 16, 2026

Search Tags:#performance #database #audit #integrity #anti-pattern

Ready to run

npx skills add https://github.com/Hainrixz/claude-db --skill db-antipatterns

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: db-antipatterns
Source: https://github.com/Hainrixz/claude-db/tree/main/skills/db-antipatterns
Command: npx skills add https://github.com/Hainrixz/claude-db --skill db-antipatterns

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Identifies common anti-patterns across different database paradigms, ensuring database schemas are designed for integrity and performance.

Core Features & Use Cases

Cross-Paradigm Analysis: Checks for issues in both relational and NoSQL databases.
Automated Detection: Automatically identifies problematic patterns like EAV tables, god tables, and unbounded array growth.
Detailed Reporting: Provides evidence and commands to reproduce issues, aiding in fixing database problems.

Quick Start

Use the db-antipatterns skill to analyze the database schema 'example_schema.db' and receive a report on potential anti-patterns.

Frequently Asked Questions about db-antipatterns

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

FAQPage Schema

How do I detect database anti-patterns in my schema?▼

To detect database anti-patterns, you can run an automated schema analysis that identifies problematic structures like god tables and EAV tables. The tool scans schemas and reports modeling issues affecting data integrity and performance.

What are common database anti-patterns I should look for during an audit?▼

Common database anti-patterns include EAV tables, god tables, and unbounded array growth. An audit checks for these issues across relational and NoSQL databases to ensure schemas maintain integrity and query performance.

Can I check for NoSQL schema design issues like unbounded array growth?▼

Yes, you can check for NoSQL schema design issues like unbounded array growth. The cross-paradigm analysis feature specifically targets both relational and NoSQL databases to detect problematic patterns and optimize performance.

What's the best way to identify EAV tables and god tables in my database?▼

The best way to identify EAV tables and god tables is through automated detection scripts that analyze schema structures. This process automatically flags problematic patterns and provides evidence to reproduce and fix database issues.

Do I need scripting skills to audit a database schema for performance optimization?▼

Yes, you need scripting and data analysis skills to audit a database schema for performance optimization. The detection process applies to schema design workflows and requires executing scripts to analyze and report anti-patterns.