aetherdb-js

Official JavaScript/TypeScript client for AetherDB — the AI-native database infrastructure.

Installation

npm install aetherdb-js

Quick start

import { AetherDB } from 'aetherdb-js'

const db = new AetherDB({
  url: 'https://aetherdb.cloud',
  token: 'your-jwt-token'
})

// Query your isolated database
const { rows } = await db.from('products').select('*').execute()

// AI-powered queries — plain English
const result = await db.ai('how many products cost more than $20?')
console.log(result.generated_sql) // SELECT COUNT(*) FROM products WHERE price > 20
console.log(result.rows)          // [{ count: 5 }]

Authentication

const db = new AetherDB({ url: 'https://aetherdb.cloud' })

// Register — gets you an isolated database schema automatically
await db.register('[email protected]', 'your-password')

// Sign in
const { access_token, user } = await db.signIn('[email protected]', 'your-password')
console.log(user.schema) // tenant_42 — your isolated schema

Create tables

await db.createTable('products', [
  { name: 'title',       type: 'TEXT',    nullable: false },
  { name: 'price',       type: 'NUMERIC', nullable: false },
  { name: 'description', type: 'TEXT',    nullable: true  },
])

Query builder

// Select with filters
const { rows } = await db
  .from('products')
  .select('title, price')
  .gt('price', 10)
  .order('price', 'DESC')
  .limit(10)
  .execute()

// Insert
const { id } = await db.from('products').insert({
  title: 'Pro Plan',
  price: 29.99
})

AI queries

// Natural language → SQL → results
const result = await db.ai('which products were added this week?')
console.log(result.generated_sql)  // generated SQL
console.log(result.rows)           // query results
console.log(result.execution_time_ms) // how fast it ran

Tenant info

// Get your postgres connection string
const info = await db.getTenantInfo()
console.log(info.connection_string)
// postgres://user:[email protected]:5432/aetherdb?search_path=tenant_42

API reference

| Method | Description | |--------|-------------| | db.register(email, password) | Create account + provision schema | | db.signIn(email, password) | Login and get token | | db.from(table) | Start a query builder | | db.ai(question) | Natural language query | | db.query(sql) | Raw SQL query | | db.createTable(name, columns) | Create a table | | db.getSchema() | List all your tables | | db.getTenantInfo() | Get connection string | | db.health() | Check server status |

License

MIT