Getting Started

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

# Authenticate with your account
mosta auth login

# Initialize a new project
mosta init my-database

// Create a new schema programmatically
import { Mosta } from "@mosta/sdk";

const mosta = new Mosta({ apiKey: process.env.MOSTA_API_KEY });

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

// Add a users table
await mosta.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 mosta.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)
mosta export --schema my-app-db --lang typescript --orm drizzle

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

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