npm install mdxdb

import { createDatabase } from '@mdxdb/fs'
 
const db = createDatabase({
  path: './content',
})
 
// Store a document
await db.set('posts/hello-world', {
  data: {
    $type: 'BlogPost',
    title: 'Hello World',
    author: 'Jane Doe',
  },
  content: '# Hello World\n\nWelcome to my blog!',
})
 
// Retrieve a document
const doc = await db.get('posts/hello-world')
console.log(doc.data.title) // 'Hello World'
 
// List all documents
const posts = await db.list('posts/')
console.log(posts.length) // 1

import { createDatabase } from '@mdxdb/sqlite'
 
const db = createDatabase({
  filename: './content.db',
})
 
// Same API as file system
await db.set('docs/getting-started', doc)
const result = await db.get('docs/getting-started')

interface Database {
  /** Get a document by path */
  get(path: string, options?: GetOptions): Promise<MDXLDDocument | null>
 
  /** Store a document */
  set(path: string, doc: MDXLDDocument, options?: SetOptions): Promise<SetResult>
 
  /** Delete a document */
  delete(path: string, options?: DeleteOptions): Promise<DeleteResult>
 
  /** List documents */
  list(prefix?: string, options?: ListOptions): Promise<ListResult>
 
  /** Search documents */
  search(query: string, options?: SearchOptions): Promise<SearchResult>
}

interface GetOptions {
  /** Include content in response */
  includeContent?: boolean
}

interface SetOptions {
  /** Overwrite existing document */
  overwrite?: boolean
  /** Create parent directories/collections */
  createParents?: boolean
}

interface ListOptions {
  /** Maximum results to return */
  limit?: number
  /** Pagination offset */
  offset?: number
  /** Sort order */
  orderBy?: 'path' | 'createdAt' | 'updatedAt'
  /** Sort direction */
  order?: 'asc' | 'desc'
  /** Filter by type */
  type?: string
}

interface SearchOptions {
  /** Fields to search */
  fields?: ('title' | 'content' | 'data')[]
  /** Maximum results */
  limit?: number
  /** Filter by type */
  type?: string
}

import { parse } from 'mdxld'
 
// From MDX string
const doc = parse(`---
$type: Article
title: My Article
---
 
# My Article
 
Content here...
`)
 
await db.set('articles/my-article', doc)
 
// From object
await db.set('articles/another', {
  data: {
    $type: 'Article',
    title: 'Another Article',
  },
  content: '# Another Article\n\nMore content...',
})

// List all articles
const articles = await db.list('articles/', {
  type: 'Article',
  orderBy: 'createdAt',
  order: 'desc',
  limit: 10,
})
 
// Search content
const results = await db.search('typescript tutorial', {
  fields: ['title', 'content'],
  limit: 20,
})

const doc = await db.get('articles/my-article')
 
// Modify the document
doc.data.title = 'Updated Title'
doc.data.updatedAt = new Date().toISOString()
 
// Save changes
await db.set('articles/my-article', doc, { overwrite: true })

await db.delete('articles/old-article')
 
// Delete with confirmation
const result = await db.delete('articles/important')
if (result.success) {
  console.log('Document deleted')
}

import { createApiClient } from 'mdxdb/client'
 
const client = createApiClient({
  baseUrl: 'https://api.example.com/mdxdb',
  apiKey: process.env.MDXDB_API_KEY,
})
 
// Same interface as local database
const doc = await client.get('posts/hello-world')

import { createSource } from '@mdxdb/fumadocs'
import { loader } from 'fumadocs-core/source'
 
const db = createDatabase({ path: './content' })
const docs = await db.list('docs/')
 
const source = createSource(
  docs.map(doc => [doc.path, doc]),
  { basePath: 'docs' }
)
 
export const docsSource = loader({
  source,
  baseUrl: '/docs',
})