simstudio-migrations

simstudio-migrations

Docker app from rorar's Repository

Overview

Sim Studio Database Migration Runner. This container runs database migrations to initialize and update the PostgreSQL schema for Sim Studio. This is a one-time setup container. It runs migrations and exits. Must complete successfully before starting simstudio-app and simstudio-realtime.

Sim.ai Documentation Slack X

Ask DeepWiki Set Up with Cursor

Sim — Integrate, Context, Build, and Monitor AI agents

A workspace to build, deploy and manage AI agents and workflows.

Quickstart

Cloud-hosted: sim.ai

Open sim.ai

Self-hosted

npx simstudio

Open http://localhost:3000

Docker must be installed and running. Use -p, --port <port> to run Sim on a different port, or --no-pull to skip pulling the latest Docker images.

The Sim platform — chat on the left, the visual workflow builder on the right

Capabilities

  • Connect 1,000+ integrations and every major LLM
  • Add Slack, Notion, HubSpot, Salesforce, databases, and more
  • Build agents visually, conversationally, or with code
  • Ingest files, knowledge bases, and structured table data
  • Monitor runs, logs, schedules, and workflow activity

One workspace, every surface

Chat and workflows are just the start — tables, files, knowledge, and scheduled tasks all live in the same workspace.

Tables in Sim — structured data your agents can query

Tables — a database, built in

Files in Sim — documents for your team and every agent

Files — one store for your team and every agent

Knowledge bases in Sim — synced docs your agents can search

Knowledge — your agents' memory

Scheduled tasks in Sim — recurring agent runs on a calendar

Scheduled tasks — runs on your schedule

Self-hosting

Docker Compose

git clone https://github.com/simstudioai/sim.git && cd sim
docker compose -f docker-compose.prod.yml up -d

Open http://localhost:3000

Sim also supports local models via Ollama and vLLM. See the Docker self-hosting docs for setup details.

Manual Setup

Requirements: Bun, Node.js v20+, PostgreSQL 12+ with pgvector

  1. Clone and install:
git clone https://github.com/simstudioai/sim.git
cd sim
bun install
bun run prepare  # Set up pre-commit hooks
  1. Set up PostgreSQL with pgvector:
docker run --name simstudio-db -e POSTGRES_PASSWORD=your_password -e POSTGRES_DB=simstudio -p 5432:5432 -d pgvector/pgvector:pg17

Or install manually via the pgvector guide.

  1. Configure environment:
cp apps/sim/.env.example apps/sim/.env
# Create your secrets
perl -i -pe "s/your_encryption_key/$(openssl rand -hex 32)/" apps/sim/.env
perl -i -pe "s/your_internal_api_secret/$(openssl rand -hex 32)/" apps/sim/.env
perl -i -pe "s/your_api_encryption_key/$(openssl rand -hex 32)/" apps/sim/.env
# DB configs for migration
cp packages/db/.env.example packages/db/.env
# Edit both .env files to set DATABASE_URL="postgresql://postgres:your_password@localhost:5432/simstudio"
  1. Run migrations:
cd packages/db && bun run db:migrate
  1. Start development servers:
bun run dev:full  # Starts Next.js app and realtime socket server

Or run separately: bun run dev (Next.js) and cd apps/sim && bun run dev:sockets (realtime).

Chat API Keys

Chat is a Sim-managed service. To use Chat on a self-hosted instance:

  • Go to https://sim.ai → Settings → Chat keys and generate a Chat API key
  • Set COPILOT_API_KEY environment variable in your self-hosted apps/sim/.env file to that value

Environment Variables

See the environment variables reference for the full list, or apps/sim/.env.example for defaults.

Tech Stack

Next.js · Bun · PostgreSQL · Drizzle · Better Auth · Tailwind — and the rest of the stack

Contributing

We welcome contributions! Please see our Contributing Guide for details.

License

This project is licensed under the Apache License 2.0 - see the LICENSE file for details.

Built by the Sim team in San Francisco

Install simstudio-migrations on Unraid in a few clicks.

Find simstudio-migrations in Community Apps on your Unraid server, review the template, and click Install. Unraid handles the Docker app or plugin setup from the published template.

Open the Apps tab on your Unraid server Search Community Apps for simstudio-migrations Review the template variables and paths Click Install

Requirements

Requires simstudio-db on the same Docker network (simstudio_internal). Must run and complete successfully before starting simstudio-app and simstudio-realtime. This is a one-time setup container.

IMPORTANT: Before adding this container, you must create the Docker network 'simstudio_internal' first. Follow these steps in Unraid:

  1. Open Terminal (Go to Main, click Terminal button)
  2. Run: docker network create simstudio_internal
  3. Go to Settings > Docker
  4. Set "Enable Docker" to "No" and click Apply
  5. Set "Preserve user defined networks" to "Yes" and click Apply
  6. Set "Enable Docker" to "Yes" and click Apply
  7. The network is now ready for use with all Sim Studio containers

Related apps

Details

Repository
ghcr.io/simstudioai/migrations:latest
Last Updated2026-07-17
First Seen2026-07-17

Runtime arguments

Network
simstudio_internal
Shell
sh
Privileged
false
Extra Params
--restart=no

Template configuration

--- Database ---Variable

PostgreSQL connection settings. Must match simstudio-db configuration.

DATABASE_URLVariable

PostgreSQL connection URL (format: postgresql://user:password@host:port/database). Must match simstudio-db.

Default
postgresql://postgres:postgres@simstudio-db:5432/simstudio
Value
postgresql://postgres:postgres@simstudio-db:5432/simstudio
--- System ---Variable

Timezone configuration.

Variable: TZVariable

Timezone. See: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List

Target
TZ
Default
Europe/Berlin
Value
Europe/Berlin
--- Advanced ---Variable

Advanced settings for troubleshooting.

LOG_LEVELVariable

Log verbosity: error, warn, info, debug

Default
info
Value
info