Getting Started

# Install the rexona CLI globally
npm install -g @rexona/cli

# Authenticate with your account
rexona auth login

# Initialize a new project
rexona init my-database

// Create a new schema programmatically
import { Rexona } from "@rexona/sdk";

const rexona = new Rexona({ apiKey: process.env.rexona_API_KEY });

const schema = await rexona.schemas.create({
  name: "my-app-db",
  database: "postgresql",
  description: "Main application database",
});

// Add a users table
await rexona.tables.create(schema.id, {
  name: "users",
  attributes: [
    { name: "id", type: "uuid", primaryKey: true, default: "gen_random_uuid()" },
    { name: "email", type: "varchar(255)", unique: true, notNull: true },
    { name: "name", type: "varchar(255)", notNull: true },
    { name: "created_at", type: "timestamp", default: "now()" },
  ],
});

// Define a one-to-many relationship
await rexona.relationships.create(schema.id, {
  from: { table: "users", attribute: "id" },
  to: { table: "posts", attribute: "author_id" },
  type: "one-to-many",
  onDelete: "CASCADE",
});

# Export to TypeScript (Drizzle ORM)
rexona export --schema my-app-db --lang typescript --orm drizzle

# Export to Python (SQLAlchemy)
rexona export --schema my-app-db --lang python --orm sqlalchemy

# Export raw SQL migrations
rexona export --schema my-app-db --format sql --output ./migrations