Guide database modeling, schema design, and security compliance for SQL, NoSQL, and vector databases.
npx skills add https://github.com/first-fluke/oh-my-agent --skill db-agent
Please help me install this Agent Skill. Skill: db-agent Source: https://github.com/first-fluke/oh-my-agent/tree/main/.agents/skills/db-agent Command: npx skills add https://github.com/first-fluke/oh-my-agent --skill db-agent
This Skill provides expert guidance on designing, optimizing, and securing databases, ensuring data integrity, performance, and compliance.
Design a relational database schema for an e-commerce platform, focusing on normalization and security.
High-intent search queries and answers about installing and using this skill.
Database schema design for an e-commerce platform requires balancing normalization for data integrity with performance tuning and security compliance. You must model relational structures, optimize indexing, and ensure adherence to ISO 27001/27002 standards to prevent common vulnerabilities.
Performance tuning for SQL databases involves optimizing indexing strategies, data partitioning, and query execution plans. Proper schema design and capacity planning ensure efficient data retrieval and maintain system performance as your data volume scales.
Vector database schema design for RAG architecture requires structuring high-dimensional vector embeddings alongside relational metadata. You must model the vector storage to optimize similarity search performance while maintaining data integrity and query efficiency.
Database compliance design requires strict adherence to ISO 27001/27002 for information security management and ISO 22301 for business continuity. Integrating these standards during schema design ensures data integrity, security, and resilience against operational disruptions.
Schema design principles differ between SQL and NoSQL databases due to their distinct data models. While SQL relies on normalization and relational constraints, NoSQL design focuses on access patterns, denormalization, and capacity planning to optimize specific query workloads.
Database capacity planning during schema modeling anticipates future storage needs and query loads. Integrating capacity planning early prevents costly performance bottlenecks and ensures your data architecture scales seamlessly without requiring disruptive migrations.
lexicalninjaDesign database schemas, migrations, and data access layers for applications.
Nick777-PixelGenerate TypeScript ORM migrations and models from Drizzle schema definitions for PostgreSQL projects.
calcosmicEnforce API security controls for authentication, authorization, and rate limiting.
inbharataiGenerate up/down database migration scripts for Alembic, Flyway, and Liquibase.
