skills.rest
Hainrixz
HainrixzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Hainrixz/claude-db --skill db-antipatterns
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
Tonybleything76Tonybleything76

Database Designer

Analyze SQL DDL and JSON schemas for normalization and constraints.

Community
Advanced
abranjithabranjith

build-data-model

Design normalized relational data models from plain-language domain requirements.

Community
Advanced
armanzeroeightarmanzeroeight
29

query-optimizer

Analyze SQL execution plans and rewrite queries for better performance.

Community
Advanced
anolilabanolilab
214

lunora-migration-helper

Manage breaking schema transitions and data backfills across ShardDO, D1, and Hyperdrive.

Official
Advanced