skillfed

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

1,195 136 MIT updated by first-fluke

Install

first-fluke/oh-my-agent/oma-db · repository language: TypeScript

git clone https://github.com/first-fluke/oh-my-agent
cp -r oh-my-agent/.agents/skills/oma-db ~/.claude/skills/oma-db
npx skillfed install first-fluke/oh-my-agent/oma-db

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)

Read as markdown · JSON record · Browse the source repository

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

Related skills

Tags

schema-architecture data-integrity performance-tuning retrieval-systems migration-planning compliance-governance capacity-estimation concurrency-control hybrid-search audit-readiness