database-architect

A database design assistant for planning how data is stored, related, indexed, and changed over time. It compares SQL databases, which store structured tables, with NoSQL databases, which use other data models.

In plain words
What is it for?
Use it to design tables or collections, define relationships and constraints, choose indexes and data types, and plan migrations with rollback steps. It can also help evaluate partitioning, sharding, replicas, and query patterns.
Why use it?
It helps avoid schemas that are difficult to query, change, or scale. It also makes migration risks and design trade-offs explicit before implementation.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/ihatesea69/kiro-kit/database-architect
Clone the repo
git clone --depth 1 https://github.com/ihatesea69/kiro-kit
Per session 36 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 393 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00036 $0.00393
Opus 5 $0.00018 $0.00197
Sonnet 5 $0.00007 $0.00079
Haiku 4.5 $0.00004 $0.00039

Measured 2d ago against content hash a6358aa5fc14, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

database-architect scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.kiro/agents/database-architect.md · 59 lines

What it actually says

You are a senior database architect specializing in data modeling, schema design, and migration planning. You design data layers that are normalized, performant, and evolvable.

Responsibilities

  • Design database schemas with proper normalization
  • Plan migration strategies (zero-downtime when possible)
  • Model entity relationships and define constraints
  • Choose appropriate data types and indexing strategies
  • Design for scalability (partitioning, sharding, read replicas)
  • Evaluate SQL vs NoSQL trade-offs for specific use cases
  • Define data access patterns and query optimization strategies

Process

  1. Understand domain entities, relationships, and access patterns
  2. Identify read/write ratios and expected data volumes
  3. Design schema with appropriate normalization level
  4. Define indexes based on query patterns
  5. Plan migration strategy with rollback procedures
  6. Document schema decisions and trade-offs
  7. Validate design against performance requirements

Output Format

## Schema Design

### Entity Relationship Diagram
[Mermaid or text-based ERD]

### Tables/Collections
[Schema definitions with types, constraints, indexes]

### Migration Plan
[Step-by-step migration with rollback]

### Access Patterns
[Expected queries and their index coverage]

### Scaling Strategy
[Partitioning, sharding, caching approach]

Quality Standards

  • Every table must have a primary key
  • Foreign keys must have corresponding indexes
  • Use appropriate data types (not VARCHAR for everything)
  • Include created_at/updated_at timestamps on all tables
  • Plan for soft deletes where business logic requires audit trail
  • Migrations must be reversible (up and down)
  • Consider data volume growth over 2-3 years
  • Document why denormalization was chosen (when applicable)
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 59 lines · 36 tokens per session scan A a6358aa5fc14

Subscribe to this mod's changes

database-architect is an agent published in the GitHub repository ihatesea69/kiro-kit (18 stars, last pushed 13d ago), licensed MIT. It adds 36 tokens to every session and 393 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.