SkillsAdd

smithery.ai

Database Management

Guide for managing the Docklift SQLite database using Prisma.

Installation

$ npx skills add https://smithery.ai
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Shared topics
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-postgres Shared topics
prisma/skills

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, an…

263K installs
prisma-driver-adapter-implementation Shared topics
prisma/skills

Required reference for Prisma ORM 7 SQL driver adapter work.

258.3K installs
prisma-upgrade-v7 Shared topics
prisma/skills

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

258.1K installs
prisma-compute Shared topics
prisma/skills

Prisma Compute deployment and hosting guide. Use whenever the user mentions Prisma Compute, `pr…

253.4K installs

Also in this package

Other skills from smithery.ai · top by installs.

npx skills add https://smithery.ai
smithery-ai-cli 7.8K frontend-design 6.2K skill-creator 2.5K ck:ui-ux-pro-max 1.3K pdf 1.2K xlsx 966 pptx 894 docx 884 webapp-testing 1 web-design-reviewer 657

Browse all from smithery.ai

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 4,427 B
  • docs SUMMARY.md 88 B

History

  1. First recorded snapshot · 1 installs

SKILL.md

Database Management Guide

Docklift uses SQLite as its database, managed by Prisma ORM.

Schema Location

backend/prisma/schema.prisma

Database file: data/docklift.db on the host → /app/data/docklift.db in the backend container (DATABASE_URL=file:/app/data/docklift.db).

Prisma client is a Proxy singleton (lib/prisma.ts) with reconnectPrisma() after restore replaces the SQLite file. Backups use VACUUM INTO snapshots — see system_administration skill.

Migration Model: checked-in Prisma migrations

Production boot runs node dist/scripts/ensureDb.js (see backend/Dockerfile CMD):

  1. Dedupe envvariables duplicates (so unique (projectid, service_name, key) can apply)
  2. prisma migrate deploy against backend/prisma/migrations/
  3. Legacy installs that used db push (no prismamigrations history) are baselined then

repaired idempotently (publishhostport, issecret, scoped env unique). After servicename exists, repair drops legacy envvariablesprojectidkeykey and ensures envvariablesprojectidservicenamekeykey — never recreates (project_id, key).

Never ship prisma db push --accept-data-loss on container startup. Local db:push is for dev experiments only.

Schema change workflow

  1. Edit backend/prisma/schema.prisma.
  2. bunx prisma migrate dev --name <desc> (creates SQL under prisma/migrations/).
  3. bun run db:generate — typed client.
  4. Type-check: cd backend; bunx tsc --noEmit.
  5. Verify on a copy of a real DB with bun run db:ensure / container boot — not only db push.

Core Commands

Run from the backend/ directory:

bun run db:studio      # web GUI to browse/edit data
bun run db:generate    # regenerate the typed client after editing the schema
bun run db:migrate     # prisma migrate deploy
bun run db:ensure      # production-equivalent bootstrap (dedupe + migrate + repair)
bun run db:push        # local-only; do not use as the container boot path

Models

Model Table Purpose
User users Admin accounts. passwordChangedAt → JWT pwdv claim
Project projects An application: source, build settings, status
Service services One deployable unit within a project (Dockerfile, domain, ports)
Deployment deployments Build/deploy history, trigger, captured logs
EnvVariable env_variables Shared or per-service vars: servicename ("" = all services), isbuildarg / isruntime / issecret; @@unique([projectid, service_name, key])
PersistentVolume persistent_volumes Configured named-volume mounts per service
Port ports Host port pool (islocked); used only when project publishhost_port is true
Settings settings Key/value system settings (GitHub App creds, ACME email, panel domain)

Build & storage fields on Project

Field Default Meaning
build_type "auto" auto \ dockerfile \ railpack
base_directory "." Subdirectory to build from (monorepos)
dockerfile_path null Explicit Dockerfile when not auto-detecting
internal_port 3000 Port the app listens on inside the container
publishhostport false When true, publish host ports from the pool

EnvVariable: dedupe via lib/envVariables.dedupeEnvVariables() inside scripts/ensureDb.ts before migrate deploy. Invalid keys → 400; duplicates → 409.

PersistentVolume has unique constraints on (projectid, name) and (projectid, servicename, mountpath), so one service cannot mount two volumes at the same path.

All child models cascade on project delete (onDelete: Cascade) — deleting a project removes its services, deployments, env vars, volume records and frees its ports.

Troubleshooting

  • Client out of sync with schema → bun run db:generate.
  • Startup fails on migrate → check docker logs docklift-backend for [ensureDb]; never “fix” with

--accept-data-loss in the Dockerfile.

  • Fresh install has no tables → ensureDb / migrate deploy failed.
  • Restored backup looks stale → restore also reconciles projects and reloads nginx; see the

system_administration skill.