# Databases

> >-

- **Type:** Skill
- **Install:** `agentstack add skill-ihatesea69-kiro-kit-databases`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [ihatesea69](https://agentstack.voostack.com/s/ihatesea69)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [ihatesea69](https://github.com/ihatesea69)
- **Source:** https://github.com/ihatesea69/kiro-kit/tree/main/.kiro/skills/databases
- **Website:** https://www.npmjs.com/package/kiro-kit

## Install

```sh
agentstack add skill-ihatesea69-kiro-kit-databases
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Databases

Activate this skill when working with database design, queries, migrations, or optimization.

## When to Use

- Designing database schemas and relationships
- Writing complex queries or aggregation pipelines
- Optimizing slow queries with indexes and execution plans
- Planning and executing database migrations
- Configuring replication, backups, or sharding
- Choosing between SQL and NoSQL for a use case

## PostgreSQL

- Use EXPLAIN ANALYZE for query optimization
- Create indexes based on WHERE, JOIN, and ORDER BY patterns
- Use partial indexes for filtered queries
- Prefer UUID or ULID for distributed primary keys
- Use transactions for multi-statement operations
- Implement row-level security for multi-tenant apps

## MongoDB

- Design schemas around access patterns (embed vs reference)
- Use compound indexes matching query patterns
- Leverage aggregation pipeline for complex transformations
- Use change streams for real-time data sync
- Implement schema validation at the database level

## Redis

- Use appropriate data structures (strings, hashes, sorted sets, streams)
- Set TTL on all cache entries
- Use Redis transactions (MULTI/EXEC) for atomic operations
- Implement pub/sub for real-time messaging
- Use Redis Streams for reliable message queues

## Migration Rules

- Migrations must be reversible (up and down)
- Never modify a deployed migration -- create a new one
- Test migrations against production-like data volumes
- Use zero-downtime migration patterns for live systems
- Back up data before destructive migrations

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [ihatesea69](https://github.com/ihatesea69)
- **Source:** [ihatesea69/kiro-kit](https://github.com/ihatesea69/kiro-kit)
- **License:** MIT
- **Homepage:** https://www.npmjs.com/package/kiro-kit

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-ihatesea69-kiro-kit-databases
- Seller: https://agentstack.voostack.com/s/ihatesea69
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.