JoFe2/kaleidosphere-dsh-plugin

Native database analysis inside DeepSeek Harness — one plugin install, no separate KaleidoSphere checkout, service, endpoint, or startup step.

Preview compatibility: DeepSeek Harness dsh-v0.1.0-rc.8 / @deepseek-ai/dsh@0.1.0-rc.8 at 141eb6fef83422698aef7a981029e843e8161534. DSH is a Developer Preview and breaking updates may require a plugin release.

See the evidence-backed compatibility matrix for the exact host, Node.js, operating-system, and database support boundaries.

Install and try the fixture

Install DSH and pnpm, then add the immutable plugin release to DSH's shipped one-shot agent profile:

npm install --global @deepseek-ai/dsh@0.1.0-rc.8 pnpm@11.7.0
dsh plugin --profile headless add github:JoFe2/kaleidosphere-dsh-plugin#v0.1.0-preview.4
dsh --profile headless --dump-config
dsh --profile headless "Analyze the configured KaleidoSphere database and report its engine and snapshot digest."

The plugin default uses the bundled exact MSSQL synthetic fixture, so these six native tools are available immediately without a separate KaleidoSphere installation:

• kaleidosphere_status
• kaleidosphere_discovery
• kaleidosphere_analyze
• kaleidosphere_plan
• kaleidosphere_preview
• kaleidosphere_readback

A typical agent flow is status → analyze → discovery/plan/preview → readback. Every result is wrapped in the released KaleidoSphere External API v2 integrity envelope and a K1 evidence receipt. The intent set comes from the released K2 closed-intent contract. Install the same bundle into the active DSH profile when using another DSH surface; the profile must include an agent runner such as the shipped headless or Web app.

Short demo:

User: Analyze the configured database, propose a weekly order-value view, and show the readback.
Agent: kaleidosphere_status → kaleidosphere_analyze → kaleidosphere_plan
       → kaleidosphere_preview → kaleidosphere_readback
Result: deterministic fixture snapshot 293a896156d8f6269c4ad33e8d632da653ea180d35a4ea5f390b0be52ce3e44a

Configure a real source

KaleidoSphere v0.16.0's supported main runtime paths are Microsoft SQL Server and Oracle. The plugin includes both required client paths (including the exact Oracle Thin driver), so no separate driver approval or KS install is required. It accepts the existing closed chimpmaera.db/analyze-profile/v1 object directly; it does not invent a universal connection schema. Copy the relevant example into $DSH_HOME/profiles/headless/cordis.patch.yml and adjust it:

• examples/live-mssql.patch.yml
• examples/live-oracle.patch.yml

Put the database password in the environment variable named by adapter.passwordEnv, then start DSH. Password values are neither accepted in plugin config nor returned by tools.

export KS_MSSQL_PASSWORD='...'
dsh --profile headless "Analyze the configured KaleidoSphere database."

The configured principal must be read-only. The bundled KS query packs contain allowlisted metadata SELECT statements; raw rows, free SQL, credentials, source writes, and persistent Superset mutation are outside this plugin's tool surface. PostgreSQL remains the bounded v0.16.0 pilot and is not advertised here as a main live plugin path.

Advanced tool exposure

All six tools are exposed by default. Advanced profiles may set any individual entry under expose to false; omitted entries remain enabled. Values must be booleans, unknown names fail at load, and disabling all six fails because a bundle with no tool surface should be disabled or removed instead. See examples/intent-exposure.patch.yml.

Advanced external runtime

The default embedded mode owns the bundled runtime and remains the one-click path. An advanced profile may instead bind an already running KaleidoSphere v0.16.0 External API v2 service with runtimeMode: external; see examples/external-runtime.patch.yml. The plugin verifies GET /v2/capabilities and its exact product, contract, capability, and attestation digests at load, then sends closed requests only to POST /v2/intents. External mode starts no KaleidoSphere process, creates no embedded runtime directory, and rejects source because source configuration remains owned by the external installation.

External API v2 has no transport authentication in v0.16.0, so this Preview accepts only explicit loopback HTTP URLs with a port and no path, credentials, query, or fragment. A missing, incompatible, oversized, non-JSON, or non-2xx runtime fails closed. Remote binding requires a separately reviewed authenticated transport contract.

Update, unload, and remove

DSH owns bundle composition and HMR. Disabling or reconfiguring the kaleidosphere-dsh-plugin row unloads its registrations and deletes its private embedded temporary profile directory. Normal shutdown does the same. External mode never owns or stops the existing KaleidoSphere service.

dsh plugin --profile headless update kaleidosphere-dsh-plugin
dsh plugin --profile headless remove kaleidosphere-dsh-plugin

Removal deletes both the profile dependency and the bundle layer. The plugin keeps fixture/readback/discovery state in memory and leaves no service, port, background process, database file, or plugin-owned state directory behind.

Scope and provenance

This repository ships prebuilt ESM; GitHub installation needs no prepare script or build permission. It vendors the minimal analysis/API/K1/K2 runtime subset from KaleidoSphere v0.16.0 at exact commit 5a73ff8146afa0067d226cffa639efde959e8fde. See NOTICE and the vendored Apache-2.0 license.

This Preview proves the deterministic fixture and exact rc.8 load/tool/unload/remove/reinstall lifecycle. It does not claim DSH stable ABI, host-wide DSH security, malicious third-party plugin containment, production readiness, live customer-database evidence, universal database support, Superset mutation, or upstream DeepSeek endorsement.

Report suspected vulnerabilities through the private path described in the security policy; never post credentials or exploit details in a public issue.

Development

See CONTRIBUTING.md for DCO, protected-PR, compatibility, provenance, and evidence requirements.

npm test
npm run verify:package
npm run test:dsh
npm run test:dsh-agent

The exact DSH smoke installs a packed tarball into a fresh profile, checks the bundle layer and ACTIVE tool row, executes all six tools through ctx.tools.execute, exercises HMR unload/reload, removes/reinstalls the package, and proves scoped temporary cleanup.

The agent smoke packs the current candidate by default, or accepts an explicit immutable release TGZ, installs it into fresh rc.8 headless profiles, and sends a natural-language task through the real headless runner, Agent Loop, model-facing tool schema, tool executor, and KS fixture. Its local deterministic model stub deliberately forces kaleidosphere_analyze; the test proves the assembled agent pipeline, not that a real LLM semantically chose the tool.

npm run verify:release -- <release.tgz> <release.tgz.sha256> additionally checks an immutable local or GitHub-hosted release asset and its sidecar before running that same exact-host lifecycle against the downloaded bytes.