Идеально для агентов ИИ, которым требуются продвинутые возможности проектирования и эксплуатации баз данных. База данных - это система управления данными, которая хранит и предоставляет доступ к данным

How do I install database?

Run the command: npx killer-skills add misty-step/canary/database. It works with Cursor, Windsurf, VS Code, Claude Code, and 19+ other IDEs.

What are the use cases for database?

Key use cases include: Проектирование нормализованных баз данных с первичными ключами UUIDv7 для распределенных систем, Реализация ограничений внешних ключей с ON DELETE RESTRICT для безопасных отношений данных, Оптимизация производительности базы данных путем выбора подходящих типов данных, таких как DECIMAL и DATE.

Which IDEs are compatible with database?

This skill is compatible with Cursor, Windsurf, VS Code, Trae, Claude Code, OpenClaw, Aider, Codex, OpenCode, Goose, Cline, Roo Code, Kiro, Augment Code, Continue, GitHub Copilot, Sourcegraph Cody, and Amazon Q Developer. Use the Killer-Skills CLI for universal one-command installation.

Are there any limitations for database?

Требует понимания концепций базы данных и принципов проектирования схемы. Может потребовать корректировки для платформо-специфичных шаблонов и ограничений базы данных.

database

Install database, an AI agent skill for AI agent workflows and automation. Works with Claude Code, Cursor, and Windsurf with one-command setup.

SKILL.md

Readonly

Imported Repository Instructions

The section below is supporting source material from the upstream repository. Use the Killer-Skills review above as the primary decision layer.

Supporting Evidence

Database

Name: database
Availability: InStock
Author: misty-step

Best practices for schema design, database operations, and platform-specific patterns.

Schema Design Principles

Primary Keys

Every table MUST have a primary key
UUIDv7 for distributed systems, auto-increment BIGINT for monoliths

Foreign Keys

Use FK constraints unless specific reason not to
ON DELETE: RESTRICT (safest), CASCADE (sparingly), SET NULL (breaks audit)

Data Types

Money: DECIMAL (never FLOAT/DOUBLE)
Dates without time: DATE not DATETIME
Small sets: ENUM not VARCHAR

Constraints

NOT NULL on required columns, UNIQUE on natural keys, CHECK for business rules

Decision Trees

"Should I denormalize?"

Evidence of query perf problem? -> Tried indexes/caching? -> Read-heavy >100:1? -> Denormalize specific fields.

"UUID or auto-increment?"

Distributed (multiple write nodes)? -> UUIDv7. Exposed to users? -> Auto-increment. Otherwise -> auto-increment.

"Soft or hard delete?"

GDPR applies? -> Hard delete. Need audit trail? -> Audit table. High deletion rate? -> Hard delete. Otherwise -> soft delete.

Database Operations

Migrations

Forward-only. No rollbacks. Maintain backward compatibility. Break large changes into smaller steps. Use feature flags during transitions.

Query Optimization

Always check EXPLAIN ANALYZE before optimizing. Index based on actual query patterns. Monitor unused indexes. Remove if idx_scan < 100.

N+1 Prevention

Always eager load in loops. Use joinedload or equivalent.

Transactions

Scope to single business operation. Keep short. Never hold during external calls.

Connection Pooling

Size based on measured peak concurrency. Alert at 80% utilization.

Anti-Patterns

EAV (entity-attribute-value) patterns
God tables (>50 columns)
Multi-valued fields (CSV in columns)
Rollback migrations
N+1 queries in loops
Long transactions with external calls

References

Reference	Content
`references/schema-design.md`	Detailed schema principles, anti-patterns, normalization
`references/operations.md`	Migrations, queries, transactions, connection pooling
`references/convex.md`	Convex-specific patterns (indexes, pagination, ctx.auth, model/)

Об этом навыке

Возможности

# Core Topics

Killer-Skills Review

Зачем использовать этот навык

Подходит лучше всего

↓ Реализуемые кейсы использования for database

! Безопасность и ограничения

Why this page is reference-only

Source Boundary

Browser Sandbox Environment

⚡️ Ready to unleash?

FAQ & Installation Steps

? Frequently Asked Questions

What is database?