Evaluate primary-key usage in relational database schemas by parsing DDL statements.
npx skills add https://github.com/Hainrixz/claude-db --skill db-keys
Please help me install this Agent Skill. Skill: db-keys Source: https://github.com/Hainrixz/claude-db/tree/main/skills/db-keys Command: npx skills add https://github.com/Hainrixz/claude-db --skill db-keys
This Skill unit provides a thorough audit of your database primary-key strategy, ensuring optimal design and performance.
Use the db-keys skill to analyze your database primary keys for potential problems.
High-intent search queries and answers about installing and using this skill.
To audit a database primary-key strategy, parse DDL statements to evaluate primary-key definition and usage, generating design integrity and performance scores to identify scaling or query efficiency issues.
Avoid UUIDv4 as a clustered index when scaling relational databases, because random UUID insertion causes fragmentation and degrades write performance; instead, choose sequential UUIDs or integers based on data volume.
Integer width choice directly impacts primary-key performance because exhausting an int4 serial column limits data volume capacity; evaluating table behavior and data volume helps select the correct integer width to prevent future exhaustion.
Yes, you can check a database schema for missing or inappropriate primary keys by parsing DDL statements to detect tables lacking proper primary-key definitions, ensuring data integrity and preventing future database performance issues.
The best way to optimize primary-key usage for database scaling is to evaluate UUID and integer width choices against actual data volume and table behavior, ensuring the clustered index supports efficient query scaling.
diadia0000Manage Dexie/IndexedDB schema for multiplayer game worlds and players.
ntaksh42Generate SQL and TypeORM database migration scripts with rollback support.
LeoTechProReview database schema changes and migration scripts before deployment.
Serg28Detect performance bottlenecks in Laravel or PHP applications via static analysis and profiling.
