← Back to Skills Marketplace
Middleware Query
by
gakkiismywife
· GitHub ↗
· v1.0.0
· MIT-0
194
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install middleware-query
Description
Natural-language read-only querying for MySQL, Redis, and MongoDB with explicit connection configuration (host, port, username, password), guarded query plan...
Usage Guidance
This skill appears to do what it says: translate NL into guarded, read-only DB queries and run them against explicit connection profiles. Before installing: 1) Keep your connections.json local and gitignored (the docs make this recommendation). 2) Review and control which DB credentials you give it — the tool needs host/port/user/password to connect. 3) If you don't want any queries or user text sent to OpenAI, do not set OPENAI_API_KEY (the planner will fall back to a local rule-based router). 4) Run the Python dependencies in an isolated environment and inspect connections.json and any saved plan files if you keep them. 5) Note masking is implemented for common sensitive field names, but confirm it covers any custom secret field names you care about.
Capability Analysis
Type: OpenClaw Skill
Name: middleware-query
Version: 1.0.0
The middleware-query skill bundle provides a structured and safety-conscious framework for querying MySQL, Redis, and MongoDB. It implements a multi-stage pipeline (Plan -> Guard -> Execute) that enforces read-only operations through regex patterns and command whitelists in scripts like query_sql.py, query_redis.py, and query_mongo.py. Additionally, it includes a sensitive data masking utility in _common.py to redact passwords and PII from query results, and it follows best practices by requiring local configuration of credentials via a gitignored connections.json file.
Capability Assessment
Purpose & Capability
The name/description (read-only NL queries for MySQL/Redis/Mongo) matches the included scripts and referenced config. The skill asks for database connection parameters (host/port/username/password) which are appropriate and necessary for the stated functionality. No unrelated services or credentials are requested.
Instruction Scope
SKILL.md and the scripts stick to the declared scope (collect connection info, produce guarded read-only plans, execute using script-level executors). One privacy-related behavior to note: the optional LLM planner (when OPENAI_API_KEY is set) will send the user NL request (and default profile names) to OpenAI. The skill documents this fallback and how to disable it by not setting OPENAI_API_KEY. Also, the JSON schema allows additionalProperties, so a returned plan could include unexpected fields — the current execution flow does not use arbitrary extra fields, but it's worth knowing.
Install Mechanism
There is no remote install/download step. The skill is instruction/code-only and ships Python scripts. No external archives or URL downloads are used. Optional Python packages are documented (openai, jsonschema, pymongo, redis, pymysql), which is expected for DB clients and LLM integration.
Credentials
The skill sensibly uses database-specific environment variables (MYSQL_*, REDIS_*, MONGO_*) and optionally OPENAI_API_KEY for planner LLM access. The registry declared no required envs; that matches reality because envs are optional fallbacks or used only if you enable the LLM planner. Requesting DB credentials (via connections.json or envs) is proportionate to the task; ensure you only provide credentials you intend the skill to access.
Persistence & Privilege
always is false and the skill does not request elevated agent-wide privileges. It stores/reads a local connections.json and writes temporary plan JSON files; this is normal for a CLI-style skill. It does not modify other skills or global agent configuration.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install middleware-query - After installation, invoke the skill by name or use
/middleware-query - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release: NL query for MySQL/Redis/Mongo with guarded execution, multi-env env/alias profile selector, and one-command entry.
Metadata
Frequently Asked Questions
What is Middleware Query?
Natural-language read-only querying for MySQL, Redis, and MongoDB with explicit connection configuration (host, port, username, password), guarded query plan... It is an AI Agent Skill for Claude Code / OpenClaw, with 194 downloads so far.
How do I install Middleware Query?
Run "/install middleware-query" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Middleware Query free?
Yes, Middleware Query is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Middleware Query support?
Middleware Query is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Middleware Query?
It is built and maintained by gakkiismywife (@gakkiismywife); the current version is v1.0.0.
More Skills