oma-db
oma-db guides you through relational, document, and vector data modeling with schema documentation, integrity rules, and transaction design. It covers normalization, indexing, capacity planning, backup strategy, and anti-pattern remediation, plus ISO 27001/27002-aligned recommendations for security and continuity.
oma-db helps you design and review database schemas, ERDs, and table structures for SQL, NoSQL, and vector workloads.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-28
oma-db helps you design and review database schemas, ERDs, and table structures for SQL, NoSQL, and vector workloads. oma-db guides you through relational, document, and vector data modeling with schema documentation, integrity rules, and transaction design. It covers normalization, indexing, capacity planning, backup strategy, and anti-pattern remediation, plus ISO 27001/27002-aligned recommendations for security and continuity.
Use it when
- oma-db helps you design or review database schema, ERD, and table structure for both relational and NoSQL workloads.
- Yes.
Verify before relying
Read SKILL.md below before installing (11 files). Open directory: indexed for reading, not audited.
Install
first-fluke/oh-my-agent/oma-db · repository language: TypeScript
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
What is oma-db and what database tasks does it help with?
oma-db guides you through relational, document, and vector data modeling with schema documentation, integrity rules, and transaction design. It covers normalization, indexing, capacity planning, backup strategy, and anti-pattern remediation, plus ISO 27001/27002-aligned recommendations for security and continuity.
How does oma-db help with database schema design for my app?
oma-db helps you design or review database schema, ERD, and table structure for both relational and NoSQL workloads. It guides normalization decisions, integrity constraints, transaction isolation levels, and data modeling best practices tailored to your application's requirements.
Can oma-db assist with query performance tuning and indexing?
Yes. oma-db optimizes query performance, indexing strategy, and database tuning. It helps you plan effective indexes, analyze query execution, and apply capacity planning techniques to ensure your database runs efficiently at scale.
Does oma-db support vector database and RAG retrieval setup?
oma-db plans vector database and RAG retrieval architecture for semantic search, including embedding versioning strategies. It helps you design retrieval pipelines that integrate with your existing relational or document stores for hybrid search workflows.
How does oma-db handle database migration and compliance?
oma-db executes schema migration with integrity, backup, and compliance safeguards. It also audits your database for anti-patterns, security risks, and ISO 27001/27002 compliance, ensuring your migration and ongoing operations meet regulatory and operational standards.
What compliance standards does oma-db address?
oma-db provides ISO 27001/27002-aligned recommendations for security, data integrity, and continuity. It helps you audit databases for anti-patterns and security vulnerabilities, and guides compliance-aware schema design for regulated workloads.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
DB Agent - Data Modeling & Database Architecture Specialist
Scheduling
Goal
Design, review, optimize, and document SQL, NoSQL, vector, and retrieval-oriented data systems with explicit schema layers, integrity rules, transaction behavior, capacity assumptions, and audit-aware tradeoffs.
Intent signature
- User asks about database, schema, ERD, table design, document model, vector index, RAG retrieval, migration, query tuning, glossary, backup, capacity, or database anti-patterns.
- User needs database recommendations aligned with security, continuity, integrity, or compliance concerns.
(truncated - see the full file via the links below)
File tree — 11 files
.agents/skills/oma-db/SKILL.md
.agents/skills/oma-db/resources/anti-patterns.md
.agents/skills/oma-db/resources/checklist.md
.agents/skills/oma-db/resources/document-templates.md
.agents/skills/oma-db/resources/error-playbook.md
.agents/skills/oma-db/resources/examples.md
.agents/skills/oma-db/resources/execution-protocol.md
.agents/skills/oma-db/resources/iso-controls.md
.agents/skills/oma-db/resources/migration-playbook.md
.agents/skills/oma-db/resources/query-tuning.md
.agents/skills/oma-db/resources/vector-db.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Design or review database schema, ERD, and table structure for relational or NoSQL workloads”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
This skill guides you through the complete lifecycle of database schema design, from conceptual modeling and logical design through physical optimization and safe migrations. It covers normalization principles, relationship patterns, indexing strategies, and query optimization techniques, with decision tables for choosing between SQL, document, and key-value storage engines. Includes zero-downtime migration patterns and backfill strategies to evolve schemas safely in production.
Database Design teaches schema fundamentals, ORM selection, and performance tuning through structured decision-making rather than rote patterns. It covers normalization, relationship design, indexing strategy, and query optimization across PostgreSQL, SQLite, and serverless databases.
Build well-structured database schemas from requirements through deployment. This skill guides you through normalization, relationship design, index optimization, and reversible migrations—covering relational databases like PostgreSQL and MySQL, document stores like MongoDB, and ORMs including Prisma, Drizzle, and TypeORM.
Database Fundamentals guides code review of schemas, queries, and migrations across SQL and NoSQL systems. It surfaces common pitfalls like N+1 queries, missing indexes, and unsafe string concatenation, while providing checklists for normalization, data types, and reversible migrations.
Database Design guides you through schema normalization, indexing strategies, and query optimization for both SQL and NoSQL systems. It covers normalization forms, denormalization trade-offs, index types, and migration patterns to help you build performant, maintainable databases. Use it when designing tables, fixing performance issues, or planning data migrations.
Master versioned, reversible database migrations that evolve schemas without downtime. Learn Alembic setup, multi-phase column operations, data backfills, and testing strategies to keep applications running during schema changes.