@sandersyao/dsh-storage-mysql
适用于 DeepSeek Harness 存储中心（ctx.storage）的 MySQL 后端
插件会安装到这里；不确定时保持 web。
npx -y @deepseek-ai/dsh plugin --profile web add github:sandersyao/dsh-storage-mysql#3d0773c30a9a49a96769728c1db2d87d0718e6cdStorage Mysql 以 @sandersyao/dsh-storage-mysql 发布，当前版本为 0.1.2。Plugin Hub 会校验它的 manifest，并保存精确安装来源，便于复现安装结果。
A cartoon dolphin in front of a bookshelf, busy at a keyboard
English | 中文
The MySQL storage backend for the DeepSeek Harness storage hub
(ctx.storage) — a drop-in, contract-equivalent alternative to the built-in
@deepseek-ai/dsh-storage-json backend. Load it as a plugin; it registers the
mysql backend on ctx.storage.backend, exposes the kv facet, and persists
KV units into MySQL (InnoDB ACID, crash-safe, cross-process visible).
This backend is one of a four-plugin set for a distributed dsh deployment on a
shared MySQL. dsh-storage-mysql (this repo), dsh-credentials-mysql, and
dsh-session-persistence-mysql switch the default storage / credentials /
session-persistence backends to shared MySQL, while dsh-workspace-bootstrap
declaratively seeds a default workspace so the first session can start on an
empty database.
| Plugin | GitHub repository | npm package page |
|---|---|---|
@sandersyao/dsh-workspace-bootstrap | https://github.com/sandersyao/dsh-workspace-bootstrap | https://www.npmjs.com/package/@sandersyao/dsh-workspace-bootstrap |
@sandersyao/dsh-credentials-mysql | https://github.com/sandersyao/dsh-credentials-mysql | https://www.npmjs.com/package/@sandersyao/dsh-credentials-mysql |
@sandersyao/dsh-session-persistence-mysql | https://github.com/sandersyao/dsh-session-persistence-mysql | https://www.npmjs.com/package/@sandersyao/dsh-session-persistence-mysql |
import { apply, Config, inject, name } from '@sandersyao/dsh-storage-mysql'
// Route the storage-domain facility to this backend:
// ctx.plugin({ apply, Config, inject, name }, { connection: { tablePrefix: 'dsh_storage_' } })
// With storage-domain config { backend: 'mysql' }, ctx.storage.domain is MySQL-backed.
Easiest path is the bundle patch (see below): add the package and its
cordis.patch.yml keeps the default storage-json backend and simply points
storage-domain.backend at mysql — the json backend stays available for
per-domain routes.
docs/DSH_PROFILE_TRIAL.md.cordis.patch.yml integration (replace the default backend) — docs/DEPLOYMENT.md.Connection details come from environment variables / a .env file (see
.env.example). Independent STORAGE_* win; they fall back to the shared
MYSQL_* — reuse the same connection when co-existing with
dsh-session-persistence-mysql / dsh-credentials-mysql, or configure
independently. The plugin Config is optional (only non-secret overrides);
credentials never live in code or config.
| Env | Fallback | Default | Purpose |
|---|---|---|---|
STORAGE_HOST | MYSQL_HOST | 127.0.0.1 | Host. |
STORAGE_PORT | MYSQL_PORT | 3306 | Port. |
STORAGE_USER | MYSQL_USER | — (required) | Least-privilege DB user. |
STORAGE_PASSWORD | MYSQL_PASSWORD | — (required) | Password. |
STORAGE_DATABASE | MYSQL_DATABASE | — (required) | Target database. |
STORAGE_TABLE_PREFIX | MYSQL_TABLE_PREFIX | — (required) | Table prefix, validated ^[A-Za-z0-9_]+$; base names distinct from session/credentials. |
STORAGE_SSL_REQUIRED | MYSQL_SSL_REQUIRED | false | TLS (deferred). |
STORAGE_POOL_SIZE | MYSQL_POOL_SIZE | 10 | Pool sizing. |
STORAGE_SCHEMA_AUTO_MIGRATE | MYSQL_SCHEMA_AUTO_MIGRATE | true | Auto-migrate schema on startup. |
Test isolation. Automated tests run against a separate database (
STORAGE_TEST_DATABASE, defaulttest);MYSQL_ROOT_PASSWORDis used only by the test harness to create/grant it.
Three tables under the prefix:
Pstorage_units — unit → format version + global_json (NULL = never-written).Pstorage_records — (unit_name, table_name, record_key) → JSON value.Pstorage_meta — applied schema version.Base names differ from session-persistence and credentials, so even sharing a
database and prefix causes no collision. unit_name/table_name/record_key are
always parameter-bound (never used as SQL identifiers); only the validated prefix
is interpolated into backticked table names.
mysql; ctx.provide(storageBackendServiceKey('mysql'), backend).kv.open validates names against UNIT_NAME_RE, materializes/version-checks a
unit, and enforces one live handle per unit.KvUnit: loadAll (transactional snapshot; global null sentinel),
putRecord (upsert), deleteRecord (idempotent), setGlobal, close.version-mismatch, malformed-medium, closed (via
StorageError).Startup runs idempotent CREATE TABLE IF NOT EXISTS, then reads
Pstorage_meta; an applied version higher than expected fails closed
(downgrade unsupported). With STORAGE_SCHEMA_AUTO_MIGRATE=false, a mismatch
fails instead of migrating.
pnpm install
pnpm typecheck && pnpm lint && pnpm build
docker compose up -d # or reuse a running MySQL
pnpm test # 35 tests
pnpm test:coverage # coverage gate (lines ≥ 90)
pnpm smoke # manual smoke (build first)
MIT