astro-dblisted

# Astro DB Type-safe SQL database built into Astro, powered by libSQL/Turso. Use for structured data without external backend services. ## 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: `column.text()`, `column.number()`, `column.boolean()`, `column.date()`, `column.json()`. ### CRUD Operations Import `db` and table from `astro:db`. All operations are async and type-safe based on your schema definition. ### Turso for Production Set `ASTRO_DB_REMOTE_URL` and `ASTRO_DB_APP_TOKEN` environment variables. Run `astro