kamehadb: Instructions file for Codex

AGENTS.md

This file provides guidance for coding agents working in this repository.

Project Overview

KamehaDB is a local-first database GUI centered on a Tauri desktop app plus a local Node sidecar. The current app supports PostgreSQL, MySQL, SQLite, MongoDB, Redis, Qdrant, SQL Server, Oracle, ClickHouse, DuckDB, MariaDB, and TigerBeetle. It includes schema browsing, a Monaco SQL editor, query history, PostgreSQL stats views, schema timeline/diff workflows, Redis/Mongo/Qdrant/TigerBeetle explorers, embedded PostgreSQL and Mongo shells, PostgreSQL backup/restore flows, pgvector exploration tools, an in-app logs viewer, and an AI chat panel with schema-aware context.

There is also a separate marketing/docs site in landing/, but it is not part of the pnpm workspace used by the desktop app and sidecar.

Repository Layout

├── apps/
│   ├── desktop/          # Tauri v2 + React 19 desktop app
│   └── sidecar/          # Hono HTTP server + DB adapters + metadata SQLite
├── packages/
│   ├── shared/           # Shared Zod schemas, app state types, adapter contracts
│   └── ui/               # Shared UI utilities/components
├── landing/              # Separate Next.js marketing site (not in pnpm workspace)
├── docker-compose.yml    # Local dev databases
└── docker-init/          # Seed SQL for Postgres/MySQL/MariaDB

Workspace And Package Boundaries

• The pnpm workspace includes only apps/* and packages/*.
• landing/ has its own package-lock.json and is managed separately with npm.
• Most root scripts target the pnpm workspace only. Do not assume they affect landing/ unless they explicitly use npm --prefix landing.
• Landing site image generation: use node scripts/capture-images.mjs to update the AI Compare panel screenshots in public/images/.
• Landing animated OG image: use npm --prefix landing run render:og to regenerate public/og-animated.gif (requires ffmpeg-static, runs locally — not a Vercel runtime route).

Commands