database

Universal database interface supporting multiple SQL/NoSQL variants, providers, and implementations through a unified API.

Overview

The database primitive provides a multi-dimensional database platform with:

Storage Types: Relational (SQL), Document (NoSQL), Key-Value, Column-Family, Graph, Time-Series, Vector
Implementations: SQLite, PostgreSQL, ClickHouse, MongoDB, Redis
Providers: D1 (Cloudflare), Neon, Supabase, PlanetScale, Turso

SDK Object Mapping

This primitive maps to the db SDK object - one of the 8 core platform objects:

import { db } from 'sdk.do'

// Universal SQL interface
await db.query('SELECT * FROM users WHERE active = ?', [true])

// Variant-specific APIs
await db.sqlite.backup('backup.db')
await db.postgres.notify('channel', { event: 'update' })
await db.clickhouse.optimize('events_table')

// Provider-specific APIs
await db.neon.createBranch({ name: 'feature-123' })
await db.supabase.functions.list()

Subdomain Architecture

The database primitive uses infinite free subdomains for variants and providers:

database.do                        # Root - Universal interface
├── sqlite.database.do             # SQLite variant
├── postgres.database.do           # PostgreSQL variant
├── clickhouse.database.do         # ClickHouse variant
├── mongo.database.do              # MongoDB-compatible API
├── redis.database.do              # Redis-compatible API
├── neon.database.do               # Neon provider
├── supabase.database.do           # Supabase provider
└── planetscale.database.do        # PlanetScale provider

Child Primitives

databases - Multi-database management and cross-database queries
datasets - Dataset management and version control

Quick Example

import { db } from 'sdk.do'

// Create
const business = await db.create('businesses', {
  name: 'Acme Inc',
  status: 'active',
})

// Query with relationships
const brands = await db.related(business, 'owns', 'brands')

Core Capabilities

CRUD Operations - Create, read, update, delete with semantic patterns
Graph Relationships - Define and query entity relationships
Vector Search - AI-powered semantic search with embeddings
Transactions - ACID compliance with Durable Objects
Schema Validation - Type-safe operations with schema enforcement

Access Methods

SDK

TypeScript/JavaScript library for database operations

await db.create('businesses', { name: 'Acme Inc', status: 'active' })

→ SDK Documentation

CLI

Command-line tool for database management

do db create businesses --data '{"name":"Acme Inc","status":"active"}'

→ CLI Documentation

API

REST/RPC endpoints for data operations

curl -X POST https://api.do/v1/db/businesses -d '{"name":"Acme Inc"}'

→ API Documentation

MCP

Model Context Protocol for AI-driven database queries

Create a new business named "Acme Inc" with status "active"

→ MCP Documentation

Child Primitives

databases - Multi-database management and cross-database queries
datasets - Dataset management and version control

embeddings - Vector operations for semantic search
state - Distributed state management
workflows - Database-driven workflows

database

On this page