@smartforge/db

Database schema and client for SmartForge using Drizzle ORM.

Installation

npm install @smartforge/db
# or
pnpm add @smartforge/db

Usage

Setup Database Client

import { createDbClient } from "@smartforge/db";

const db = createDbClient(process.env.DATABASE_URL!);

Database Schema

The package exports the following tables:

• users - User accounts
• projects - SmartForge projects
• projectMembers - Project membership and roles
• contracts - Smart contracts
• transactions - Transaction records
• gasUsage - Gas usage tracking
• contractEvents - Contract event logs

Example Queries

import { db, users, projects } from "@smartforge/db";
import { eq } from "drizzle-orm";

// Get user by wallet address
const user = await db
  .select()
  .from(users)
  .where(eq(users.walletAddress, "0x..."))
  .limit(1);

// Create a project
const [project] = await db
  .insert(projects)
  .values({
    name: "My Project",
    ownerId: user.id,
    apiKey: "sf_...",
  })
  .returning();

// Get user's projects
const userProjects = await db
  .select()
  .from(projects)
  .where(eq(projects.ownerId, user.id));

Database Migrations

Generate Migrations

cd packages/db
pnpm generate

Run Migrations

pnpm migrate

Schema Overview

Users

• id - UUID primary key
• walletAddress - Ethereum address (unique)
• email - Optional email
• role - User role (admin, writer, reader)
• createdAt, updatedAt - Timestamps

Projects

• id - UUID primary key
• name - Project name
• ownerId - User ID (foreign key)
• apiKey - Unique API key
• createdAt, updatedAt - Timestamps

Contracts

• id - UUID primary key
• projectId - Project ID (foreign key)
• name - Contract name
• address - Deployed contract address
• chainId - Chain ID (default: 8453 for Base)
• abi - Contract ABI (JSON)
• bytecode - Contract bytecode
• sourceCode - Solidity source code
• deploymentStatus - Status (pending, deployed, failed)
• createdAt, updatedAt - Timestamps

Transactions

• id - UUID primary key
• projectId - Project ID
• contractId - Contract ID (optional)
• txHash - Transaction hash (unique)
• from, to - Addresses
• chainId - Chain ID
• functionName - Called function
• args - Function arguments (JSON)
• gasUsed, gasPrice - Gas information
• status - Transaction status
• isGasless - Whether transaction was sponsored
• error - Error message (if failed)
• createdAt - Timestamp

License

ISC