The Database for SMEs, Personal AI Apps, and AI Agents.

using System.Net.Http;
using System.Net.Http.Json;
using System.Net.Http.Headers;

var client = new HttpClient();
var baseUrl = "http://localhost:8080";

// Authenticate and get JWT token
var login = await client.PostAsJsonAsync(
    $"{baseUrl}/api/auth/login",
    new { username = "superadmin", password = "your-password" }
);
var auth = await login.Content.ReadFromJsonAsync<AuthResponse>();
client.DefaultRequestHeaders.Authorization =
    new AuthenticationHeaderValue("Bearer", auth.Token);

// Insert a document — no ORM needed
var order = new {
    customer = "Acme Corp",
    items = new[] {
        new { sku = "WIDGET-A1", qty = 5, price = 29.99 },
        new { sku = "GADGET-B2", qty = 2, price = 49.99 }
    },
    total = 249.93,
    status = "pending"
};
var res = await client.PostAsJsonAsync($"{baseUrl}/db/Sales/Order", order);
var created = await res.Content.ReadFromJsonAsync<DocResponse>();

// Retrieve by ID
var doc = await client.GetFromJsonAsync<dynamic>(
    $"{baseUrl}/db/Sales/Order/{created.Id}");

// Query with SQL
var result = await client.PostAsJsonAsync($"{baseUrl}/sql", new {
    sql = "SELECT customer, total FROM Sales.Order WHERE status = 'pending' ORDER BY total DESC"
});

# Authenticate and get JWT token
TOKEN=$(curl -s -X POST http://localhost:8080/api/auth/login \
  -H "Content-Type: application/json" \
  -d '{"username": "superadmin", "password": "your-password"}' \
  | jq -r '.token')

# Insert a document — no schema needed
curl -s -X POST http://localhost:8080/db/Sales/Order \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $TOKEN" \
  -d '{
    "customer": "Acme Corp",
    "items": [
      {"sku": "WIDGET-A1", "qty": 5, "price": 29.99},
      {"sku": "GADGET-B2", "qty": 2, "price": 49.99}
    ],
    "total": 249.93,
    "status": "pending"
  }'

# Retrieve by ID
curl -s http://localhost:8080/db/Sales/Order/YOUR_DOC_ID \
  -H "Authorization: Bearer $TOKEN"

# Query with SQL
curl -s -X POST http://localhost:8080/sql \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $TOKEN" \
  -d '{"sql": "SELECT customer, total FROM Sales.Order WHERE status = '\''pending'\'' ORDER BY total DESC"}'