AGENT SKILL
database
Database design and management fundamentals
- License 许可
- MIT
- 最近更新
- 2026-03-01
- Stars
- ★ 3
- Forks
- 2
01 前言 Front Matter
- name
- database
- license
- MIT
- metadata
- { "audience": "developers", "category": "database" }
- description
- Database design and management fundamentals
- compatibility
- opencode
03 SKILL.md 正文
What I do
- Design database schemas
- Normalize data structures
- Create indexes for performance
- Write efficient queries
- Handle transactions
- Implement data integrity
- Optimize queries
- Manage database connections
When to use me
When designing databases or writing queries.
Schema Design
-- Normalized schema
CREATE TABLE users (
id BIGINT PRIMARY KEY,
email VARCHAR(255) NOT NULL UNIQUE,
created_at TIMESTAMP DEFAULT NOW()
);
CREATE TABLE orders (
id BIGINT PRIMARY KEY,
user_id BIGINT REFERENCES users(id),
total DECIMAL(10, 2) NOT NULL,
status VARCHAR(50) DEFAULT 'pending',
created_at TIMESTAMP DEFAULT NOW()
);
-- Index for performance
CREATE INDEX idx_orders_user ON orders(user_id);
CREATE INDEX idx_orders_status ON orders(status) WHERE status = 'pending';
Query Optimization
-- Use EXPLAIN ANALYZE
EXPLAIN ANALYZE
SELECT * FROM orders
WHERE user_id = 123
ORDER BY created_at DESC
LIMIT 20;
-- Avoid SELECT *
-- Use covering indexes
-- Pagination with LIMIT/OFFSET
-- Batch operations
04 同仓库更多 Skills
xamarin
Xamarin cross-platform development
★ 3
wrangling
Data wrangling fundamentals
★ 3
windows
Windows operating system administration and scripting
★ 3
wide-column
Wide-column data model
★ 3
wide-column-stores
Wide-column database stores
★ 3
websockets
WebSocket implementation and best practices
★ 3