Open Source · MIT License

Lightweight ORM
for Every Platform

Type-safe database access for TypeScript, Python, .NET, Golang & Rust.
SQL Server · PostgreSQL · MySQL · SQLite · Google Sheets · NBase · Qdrant · Chroma · Pinecone · Weaviate · Milvus

5 Languages
6 Databases
MIT License
an5Orm.config.js
import { createAn5Adapter } from '@an5/adapters';

const db = createAn5Adapter({
  connectionString: process.env.DATABASE_URL
});
await db.$connect();

// Type-safe query
const users = await db.user.findMany({
  where: { isActive: true },
  orderBy: { createdAt: 'desc' },
  take: 10
});

Built for modern apps

Everything you need to work with databases across all your stacks.

Blazing Fast

Zero-overhead query execution. Minimal dependencies. Works directly on your existing DB driver.

Fully Typed

First-class TypeScript support with auto-generated types from your .an5 schema files.

Multi-Platform

One schema, multiple languages. Generate clients for TypeScript, Python, .NET (C#), Golang, Rust, Java, Kotlin, and Swift simultaneously.

Google Sheets Mode

Use Google Sheets as a lightweight database backend — ideal for MVPs, no-code tools, and browser apps.

AI-Powered Agent

Built-in AI agent tools for schema exploration, SQL generation, and intelligent code review tasks.

Rate-Limit Safe

Token-bucket rate limiter + concurrency control + exponential backoff with full jitter built-in.

Up and running in minutes

# Install
npm install @an5/orm @an5/adapters

# Define schema (an5Schema/User.an5)
model User {
  id        NVARCHAR(1000)   @id @default(uuid())
  email     NVARCHAR(255)    @unique
  name      NVARCHAR(255)?
  createdAt DATETIME2        @default(now())

  @@map("users")
}

# Generate the typed clients (from an5Orm/)
npm run generate

# Use
import { createAn5Adapter } from '@an5/adapters';

const db = createAn5Adapter({ connectionString: process.env.DATABASE_URL });
const users = await db.user.findMany({ take: 10 });
# Install
pip install an5-adapters

# Use the adapter (or the generated An5Client)
import os
from an5_adapters import create_an5_adapter

db = create_an5_adapter(os.environ["DATABASE_URL"])

users = db.user.find_many(where={"isActive": True})
using An5Orm;

var db = new An5DbContext(
  "Server=.;Database=mydb;Trusted_Connection=true"
);

// Create
var user = new User { Email = "john@example.com", Name = "John" };
db.User.Create(user);

// Read (synchronous TableClient)
var users = db.User.FindMany(
  "Email = @email",
  new Dictionary<string, object> { ["email"] = "john@example.com" }
);
// Generated an5client with type-safe args
import (
  "context"
  "database/sql"
  an5 "an5client"
  _ "github.com/denisenkom/go-mssqldb"
)

sqlDB, _ := sql.Open("sqlserver", an5.GetDefaultConnectionString())
orm := an5.NewAn5DbContext(sqlDB)
ctx := context.Background()

// Find users matching an email pattern
users, err := orm.User.FindMany(ctx, &an5.UserFindManyArgs{
  Where: &an5.UserWhereInput{
    Email: &an5.StringFilter{Contains: an5.StringPtr("@example.com")},
  },
  Take: an5.IntPtr(10),
})
# Add the adapter runtime (the generated client comes from `npm run generate`)
cargo add an5-adapters
cargo add sqlx --features any,sqlserver,postgres,mysql,sqlite

# Use
use an5_client::{An5Client, SortOrder, StringFilter, UserFindManyArgs, UserOrderByInput, UserWhereInput};

// The app picks the driver; the client stays dialect-agnostic
sqlx::any::install_drivers(&[sqlx::postgres::any::DRIVER])?;
let db = An5Client::connect("postgres://localhost:5432/mydb").await?;

// Type-safe query
let users = db.user().find_many(&UserFindManyArgs {
  where_: Some(UserWhereInput {
    email: Some(StringFilter {
      contains: Some("@example.com".into()),
      ..Default::default()
    }),
    ..Default::default()
  }),
  order_by: Some(UserOrderByInput {
    created_at: Some(SortOrder::Desc),
    ..Default::default()
  }),
  take: Some(10),
  ..Default::default()
}).await?;
// Browser-compatible! No Node.js builtins
import { createAn5SheetsAdapter } from '@an5/adapters/browser';

const db = createAn5SheetsAdapter({
  spreadsheetId: 'YOUR_SHEET_ID',
  accessToken: 'YOUR_OAUTH_TOKEN'
  // or apiKey: 'YOUR_API_KEY'
});

const rows = await db.products.findMany();

Available everywhere

Published on npm, PyPI, and the VS Code Marketplace.

Schema tooling
for your editor

The AN5 ORM Schema Tooling extension provides rich support for .an5 schema files in Visual Studio Code, Cursor, and VSCodium.

  • Syntax highlighting for .an5 files
  • Code snippets (model, field, relation)
  • Status bar: Generate, Push, Pull
  • Works in VS Code, Cursor & VSCodium
schema.an5
// AN5 Schema Definition

model Product {
  id        NVARCHAR(1000)  @id @default(uuid())
  name      NVARCHAR(255)
  price     DECIMAL(10,2) @default(0)
  stock     INT          @default(0)
  category  NVARCHAR(255)?
  createdAt DATETIME2    @default(now())

  @@map("Products")
  @@index([category])
}

Works with your database

SQL Server
Stable
PostgreSQL
Stable
MySQL
Stable
SQLite
Stable
Google Sheets
Browser Ready
NBase
Vector Ready
Qdrant
Vector Ready
Chroma
Vector Ready
Pinecone
Vector Ready
Weaviate
Vector Ready
Milvus
Vector Ready