Type-safe database access for TypeScript, Python, .NET, Golang & Rust.
SQL Server · PostgreSQL · MySQL · SQLite · Google Sheets · NBase · Qdrant · Chroma · Pinecone · Weaviate · Milvus
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 });
Everything you need to work with databases across all your stacks.
Zero-overhead query execution. Minimal dependencies. Works directly on your existing DB driver.
First-class TypeScript support with auto-generated types from your .an5 schema files.
One schema, multiple languages. Generate clients for TypeScript, Python, .NET (C#), Golang, Rust, Java, Kotlin, and Swift simultaneously.
Use Google Sheets as a lightweight database backend — ideal for MVPs, no-code tools, and browser apps.
Built-in AI agent tools for schema exploration, SQL generation, and intelligent code review tasks.
Token-bucket rate limiter + concurrency control + exponential backoff with full jitter built-in.
# 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();
Published on npm, PyPI, and the VS Code Marketplace.
npm i @an5/orm
npm i @an5/adapters
npm i @an5/agent
pip install an5-adapters
pip install an5-orm
go get github.com/an5ORM/an5Adapters/golang
github.com/an5ORM/an5example
.an5 schema files, plus an MCP server for agentic clients.code --install-extension an5orm.an5-orm-vscode
ext install an5orm.an5-orm-vscode
The AN5 ORM Schema Tooling extension provides rich support for .an5 schema files in Visual Studio Code, Cursor, and VSCodium.
.an5 files
// 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]) }