数据库设计最佳实践指南：PostgreSQL、SQLite、ORM选择与性能优化

database-design by davila7/claude-code-templates

275 周安装量

23,500 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/davila7/claude-code-templates --skill database-design

开发数据库性能优化

🇨🇳中文介绍

数据库设计

学会思考，而非复制 SQL 模式。

🎯 选择性阅读规则

只阅读与请求相关的文件！ 查看内容地图，找到你需要的部分。

文件	描述	何时阅读
`database-selection.md`	PostgreSQL vs Neon vs Turso vs SQLite	选择数据库
`orm-selection.md`	Drizzle vs Prisma vs Kysely	选择 ORM
`schema-design.md`	规范化、主键、关系	设计模式
`indexing.md`

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

Database Design

Learn to THINK, not copy SQL patterns.

🎯 Selective Reading Rule

Read ONLY files relevant to the request! Check the content map, find what you need.

File	Description	When to Read
`database-selection.md`	PostgreSQL vs Neon vs Turso vs SQLite	Choosing database
`orm-selection.md`	Drizzle vs Prisma vs Kysely	Choosing ORM
`schema-design.md`	Normalization, PKs, relationships	Designing schema
`indexing.md`	Index types, composite indexes	Performance tuning
`optimization.md`	N+1, EXPLAIN ANALYZE	Query optimization
`migrations.md`	Safe migrations, serverless DBs	Schema changes

⚠️ Core Principle

ASK user for database preferences when unclear
Choose database/ORM based on CONTEXT
Don't default to PostgreSQL for everything

Decision Checklist

Before designing schema:

Asked user about database preference?
Chosen database for THIS context?
Considered deployment environment?
Planned index strategy?
Defined relationship types?

Anti-Patterns

❌ Default to PostgreSQL for simple apps (SQLite may suffice) ❌ Skip indexing ❌ Use SELECT * in production ❌ Store JSON when structured data is better ❌ Ignore N+1 queries

Weekly Installs

275

Repository

davila7/claude-…emplates

GitHub Stars

23.5K

First Seen

Jan 25, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode225

gemini-cli217

codex214

github-copilot210

claude-code191

cursor188