The backend platform
AI coding tools understand

// .sparrowbase/CLAUDE.md — Auto-loaded by AI coding agents // This file teaches Cursor, Windsurf, v0, and Claude how to // write 100% compatible Cloudflare Workers code. ## Runtime Constraints - NEVER import Node.js modules: fs, net, tls, http, child_process - NEVER use express, fastify, koa, or next/server - NEVER use bcrypt or jsonwebtoken (native C++ bindings) - ALWAYS use Hono.js for routing - ALWAYS use crypto.subtle (Web Crypto API) for hashing - ALWAYS use Drizzle ORM with D1 for database access ## Available Bindings - DB → D1 SQLite database (via Drizzle ORM) - CACHE → KV key-value store (rate limiting) - UPLOADS → R2 object storage (file uploads) - AI → Workers AI (embeddings, inference) - VECTORIZE→ Vector index (RAG search)

import { createSparrowClient } from '@sparrowbase/client'; // Initialize type-safe client const sparrow = createSparrowClient({ baseUrl: 'https://api.myapp.workers.dev', }); // Authentication const { user, session } = await sparrow.auth.signUp({ email: 'dev@example.com', password: 'securePassword123', }); // Database queries (type-safe) const users = await sparrow.get('/api/users'); // Direct streaming file upload to R2 const { publicUrl } = await sparrow.uploadFile(file, 'user_123'); // AI vector search (RAG) const results = await sparrow.ai.search('edge native databases');

import { Hono } from 'hono'; import { cors } from 'hono/cors'; import { getDb } from './db'; import { rateLimiter } from './middleware/rate-limit'; import { authMiddleware } from './middleware/auth'; const app = new Hono(); // Global middleware app.use('*', cors()); app.use('/api/*', rateLimiter({ limit: 100, window: 60 })); // Health check app.get('/api/health', (c) => c.json({ status: 'healthy' })); // Protected route with auth app.get('/api/users', authMiddleware, async (c) => { const db = getDb(c.env.DB); const users = await db.query.users.findMany(); return c.json({ success: true, data: users }); }); export default app;

import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; // Multi-tenant user table export const users = sqliteTable('users', { id: text('id').primaryKey(), email: text('email').notNull().unique(), name: text('name'), orgId: text('org_id').references(() => orgs.id), createdAt: integer('created_at', { mode: 'timestamp' }), }); // Organization for multi-tenancy export const orgs = sqliteTable('organizations', { id: text('id').primaryKey(), name: text('name').notNull(), plan: text('plan').default('free'), stripeId: text('stripe_customer_id'), }); // Subscription tracking export const subscriptions = sqliteTable('subscriptions', { id: text('id').primaryKey(), orgId: text('org_id').references(() => orgs.id), status: text('status').default('active'), plan: text('plan').default('free'), });