Skip to main content

@an5/adapters

Standalone runtime database adapter and query engine for AN5 ORM. Provides connection pooling, SQL dialect query building (parseWhere, buildOrderBy, quote), dynamic model proxy access, eager loading (include), nested writes, vector search, transactions, and typed table clients across TypeScript, Python, .NET (C#), Golang, and Google Sheets.

Features

  • Dynamic Model Access — Access models directly via db.user.findMany() or db.User.create() (proxy resolves casing/plurals via metadata); db.table('User') is the escape hatch for runtime-known model names
  • Typed Model Access — Bind generated delegates for full type-safety: createAn5Adapter<{ user: UserTableClient }>({...}), plus the TypedAn5Adapter / AdapterAPI helper types
  • Relations & Eager Loading — Query nested relations with include, relation-level select, where, orderBy, pagination, and _count
  • Nested Writes — Create and update records with nested relation writes (create, update, disconnect)
  • Query Builder & Dialects — Dialect-aware SQL formatting for MSSQL, PostgreSQL, MySQL, and SQLite
  • Aggregations & GroupBy — Standard ORM aggregates (_count, _sum, _avg, _min, _max) and groupBy
  • Field Math Operators — Atomic updates with increment, decrement, multiply, divide, set
  • Vector Search — Similarity search using pgvector (PostgreSQL), VECTOR_DISTANCE (MSSQL), or in-memory cosine/euclidean/dot similarity
  • Real Transactions — Interactive and callback transactions ($transaction(async tx => ...) and $begin()/$commit()/$rollback())
  • Cross-Language — Unified API in TypeScript, Python, .NET (C#), and Golang
  • Google Sheets Database — Use spreadsheets as a live database with full CRUD and SQL syntax support

Installation

TypeScript

npm install @an5/adapters

Python

pip install an5-adapters

.NET

dotnet add package An5Adapters

Go

# Included in the npm package under golang/ or via go module

Usage

TypeScript

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

const db = createAn5Adapter({
  connectionString: process.env.DATABASE_URL!,
});

// Dynamic model access
const users = await db.user.findMany({
  where: { active: true },
  include: {
    orders: {
      where: { status: 'paid' },
      orderBy: { total: 'desc' },
      take: 5,
    },
    _count: true,
  },
  take: 10,
});

// Nested writes
const created = await db.user.create({
  data: {
    email: 'alpha@example.com',
    name: 'Alpha',
    orders: {
      create: [
        { total: 100, status: 'open' },
        { total: 250, status: 'paid' },
      ],
    },
  },
  include: { orders: true, _count: true },
});

// Atomic updates
await db.user.update({
  where: { id: created.id },
  data: {
    score: { increment: 10 },
  },
});

// Aggregations
const stats = await db.order.aggregate({
  _count: true,
  _sum: { total: true },
  _avg: { total: true },
});
console.log(stats._count._all, stats._sum.total, stats._avg.total);

// Transactions
await db.$transaction(async (tx) => {
  await tx.user.update({
    where: { id: created.id },
    data: { score: { increment: 5 } },
  });
  await tx.order.create({
    data: { userId: created.id, total: 50, status: 'paid' },
  });
});

// Raw query
const rawRows = await db.$queryRawUnsafe('SELECT * FROM users WHERE active = @p_0', 1);

// Disconnect
await db.$disconnect();

Python

from an5_adapter import create_an5_adapter

db = create_an5_adapter("sqlserver://localhost:1433;database=mydb;user=sa;password=pass")

# Dynamic model access
users = db.user.find_many(where={"active": True}, take=10)

# Nested create
created = db.user.create({
    "data": {
        "email": "alpha@example.com",
        "name": "Alpha",
    }
})

# Transactions
def perform_transfer(tx):
    tx.user.update({"where": {"id": "u1"}, "data": {"score": {"increment": 10}}})

db.transaction(perform_transfer)

API Reference

An5Adapter

Method / Property Description
db[modelName] Dynamic proxy returning AdapterTableClient for the model
table<T>(name) Explicitly returns AdapterTableClient<T>
exec(query, params) Execute raw parameterized query returning rows
$queryRawUnsafe(sql, ...args) Positional raw query
$executeRaw(sql, ...args) Raw DML execution returning affected count
$transaction(fn) Callback transaction with automatic commit/rollback
$begin() Interactive transaction returning An5AdapterTx
$connect() Open connection / pool
$disconnect() Close connections

AdapterTableClient

Method Description
findMany(args) Query multiple records with where, orderBy, skip, take, select, include
findFirst(args) Query first matching record
findUnique(args) Query unique record by unique filter
create(args) Insert a record with support for nested relation writes
createMany(args) Bulk insert records
update(args) Update record with field math operations & nested relation writes
updateMany(args) Update multiple records
delete(args) Delete a single record
deleteMany(args) Delete multiple records
upsert(args) Insert or update a record
count(args) Count matching records
aggregate(args) Compute _count, _sum, _avg, _min, _max
groupBy(args) Group by fields with aggregations and pagination
vectorSearch(args) Semantic vector similarity search

License

MIT

Metadata

Release files for an5-adapters 0.2.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for an5-adapters 0.2.6
File Size Uploaded Provenance Actions
an5_adapters-0.2.6.tar.gz 13.3 kB Without provenance Details for an5_adapters-0.2.6.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for an5-adapters 0.2.6
File Interpreter ABI Platform Actions
an5_adapters-0.2.6-py3-none-any.whl Python 3 none any Details for an5_adapters-0.2.6-py3-none-any.whl

Total release size: 28.6 kB

Release files / an5_adapters-0.2.6.tar.gz

Download URL an5_adapters-0.2.6.tar.gz
Size 13.3 kB
Tags Source
SHA-256 checksum
How to use checksums
434b5ebc389688766ccc46afbce7faa5d979bb2e1cc9b8565ed54db37ede37e3
BLAKE2b-256 checksum
How to use checksums
bf94e508757bc8c5c4de35674d8fe36780127f1c9df306df4aca70dfbf66d292
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Release files / an5_adapters-0.2.6-py3-none-any.whl

Download URL an5_adapters-0.2.6-py3-none-any.whl
Size 15.3 kB
Tags Python 3
SHA-256 checksum
How to use checksums
f91f9c1b7bddbfaef31cfe0d0d518e07491109fa0087b53bf2f6a96d667bf076
BLAKE2b-256 checksum
How to use checksums
44db500f71a3bef0a5ca44c8c8b9deacde363e1f6e7a73231a656ea277d4a747
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Security for an5-adapters 0.2.6

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page