astro-db

# Astro DB Type-safe SQL database built into Astro, powered by libSQL/Turso. Use for structured data without external backend services. > **⚠️ Deprecation notice**: `@astrojs/db` is **deprecated and no longer actively maintained** (still published on npm, currently v0.21.3 — it has not been removed from Astro 7). For new projects, prefer **Drizzle**, **Kysely**, or a direct **libSQL** client instead. Existing projects can keep using it, but should plan a migration. ## Agent Workflow (MANDATORY) Before ANY implementation, use `TeamCreate` to spawn 3 agents: 1. **fuse-ai-pilot:explore-codebase** - Check existing db/config.ts, tables, and Actions 2. **fuse-ai-pilot:research-expert** - Verify Astro DB API via Context7/Exa 3. **mcp__context7__query-docs** - Check Astro 6 DB docs for column types and CRUD After implementation, run **fuse-ai-pilot:sniper** for validation. --- ## Overview ### When to Use - Storing structured data (comments, users, posts, forms) - Building full-stack Astro apps without external DB setup - Combining with Astro Actions for type-safe form handling - Deploying to production with Turso (libSQL cloud) - Seeding development data for local testing ### Architecture ``` db/ ├── config.ts # Schema definition (defineDb, defineTable) └── seed.ts # Development data seeding ``` --- ## Core Concepts ### Schema Definition Define tables in `db/config.ts` using `defineDb` and `defineTable`. Export tables for use in pages and actions. Column types: ...