dsh-plugin-sql-manager
Manifest validDeepSeek Harness SQL Manager plugin: reusable SQL per system, each with its own required JSON path, searchable by note, table, and field.
SQL Manager
A DeepSeek Harness plugin that keeps reusable SQL grouped by system. Every system must have its own JSON storage path; systems can live in different folders. The page searches notes, table names, field names, and raw SQL text.
Repository: https://github.com/sijunmanyue/dsh-plugin-sql-manager
Install
git clone https://github.com/sijunmanyue/dsh-plugin-sql-manager.git
Then install the cloned directory as a DSH bundle through the Plugin Manager (or plugin_manager install_bundle with the absolute directory path), and enable SQL Manager if it is not enabled automatically.
Use
- Open SQL Manager from the sidebar.
- Create a system and fill in its required Storage path:
- a JSON file path such as
D:\SQL\crm.json, or - a folder path such as
D:\SQL\crm; the plugin creates<system-id>.jsoninside it.
- a JSON file path such as
- Add SQL to the system.
- Search by a note such as
客服, a table such ast_user, or a field such asuser_id.
Editing a system path moves its existing JSON file to the new location. If the entered path already points at a valid system JSON, that file is imported instead of overwritten.
The page also exposes the same library through the sql_manager agent tool (search, list_systems, add, update, delete, create_system, update_system, delete_system).
Storage
Each system is one self-contained JSON file. A small registry at $DSH_HOME/sql-manager/systems.json remembers the path of every system; it is an index, not a global storage folder. DSH_HOME defaults to ~/.dsh.
The suggested folder is $DSH_HOME/sql-manager/sqls, but it is only a convenience for new systems; each system path is stored and edited separately.
A system file follows this shape:
{
"schema": "dsh.sql-manager.system/v1",
"id": "crm",
"name": "CRM 订单系统",
"description": "订单域",
"path": "D:\\SQL\\crm.json",
"createdAt": "2026-01-01T00:00:00.000Z",
"updatedAt": "2026-01-01T00:00:00.000Z",
"sqls": [
{
"id": "sql-0123456789ab",
"name": "按手机号查用户",
"remark": "客服常用;按手机号精确查询",
"sql": "SELECT u.id, u.mobile FROM t_user u WHERE u.mobile = ?",
"tables": ["t_user"],
"fields": ["id", "mobile"],
"createdAt": "2026-01-01T00:00:00.000Z",
"updatedAt": "2026-01-01T00:00:00.000Z"
}
]
}
path is descriptive; the registry is authoritative. tables and fields are refreshed from the SQL text whenever the file is read, so hand-editing the SQL keeps search accurate. A missing or unreadable system file is shown as a broken system with an Edit path action, so it can be repaired or removed.
If an older installation used one global storage folder, the first run with no registry scans the legacy settings.json folder, SQL_MANAGER_DIR, and the suggested folder, then registers those system JSONs automatically.
Notes
- The HTTP API is
/api/sql-managerand accepts loopback requests only. - Deleting a system removes its JSON file and registry entry.
- There is no global storage folder setting.
Comments
Loading…
Similar plugins
by weibaohui
DeepSeek Harness plugin: cron-driven scheduled items with a full-page management UI. Each item carries a title, a prompt, and a croner expression; executions spawn a fresh agent session in a bound wor
★ 0
JavaScript
Aug 19, 2026
dsh plugin --profile web add dsh-plugin-scheduled-itemsby 1321928757
MySQL connector plugin for DeepSeek Harness: configure connections in settings, switch per session from the composer, and expose mysql_query/mysql_tables/mysql_execute tools to every agent preset.
★ 8
↓ 10/wk
MIT
JavaScript
Oct 25, 2026
dsh plugin --profile web add dsh-mysqlby SLin-code
One installable DeepSeek Harness plugin for managing Workspace → Task → Session collaboration.
★ 3
MIT
TypeScript
Aug 24, 2026
dsh plugin --profile web add dsh-task-notice-boardby STARDUSTLC666
DeepSeek Harness 工程师级数据库插件:sql_list/query/exec/schema/stats/health 六工具,SQLite/MySQL/PostgreSQL 三引擎、词法级只读保护、写审批门、行数钳制、CSV/JSON 查询输出。· Databases for DeepSeek Harness agents. 已验证兼容 DeepSeek Harness v0.1.
★ 9
↓ 2.7k/wk
MIT
JavaScript
Nov 17, 2026
dsh plugin --profile web add dsh-sqlDatabase connections and SQL for DeepSeek Harness: register data sources, browse and comment schemas, run AST-checked SQL with a per-source read-only toggle, and render bar, line and pie charts, from
★ 0
dsh plugin --profile web add @tomowang/dsh-data-agentby 173787247
DeepSeek Harness WSL plugin (dsh-wsl-db)
★ 1
MIT
JavaScript
Nov 3, 2026
dsh plugin --profile web add dsh-wsl-db