← Back to Skills Marketplace
oblio-falootin

SQL Connector

by Oblio · GitHub ↗ · v2.2.0 · MIT-0
cross-platform ⚠ suspicious
361
Downloads
0
Stars
0
Active Installs
5
Versions
Install in OpenClaw
/install sql-connector
Description
Generic SQL Server connectivity for OpenClaw agents. Use when: (1) executing parameterized queries against SQL Server, (2) building repository layers that ne...
Usage Guidance
This skill appears to implement the SQL Server connector it advertises, but there are a few red flags you should consider before installing: - Required env vars are not declared in the registry metadata. The connector expects SQL_CLOUD_*/SQL_LOCAL_* (or SQL_{IDENT}_*) variables in an .env or the process environment. Confirm you are willing to provide database credentials to this skill. - The code calls load_dotenv(..., override=True) when it finds a .env. That will overwrite existing environment variables with values from the file, which can be surprising and could unintentionally change other services' behavior. Consider storing credentials in a secure secret store or verifying .env contents before installation. - Some config (SQL_DEFAULT_BACKEND) is read at import time before .env is loaded, so behavior can differ depending on how the module is imported. Test in your environment to ensure the connector picks up the intended backend. - The README suggests installing via pip; prefer to review the pip package source or pin an exact version, and run the bundled tests in an isolated environment (or read the code) to confirm no unwanted network or file operations occur. - If you plan to use this in production, prefer least-privilege DB credentials and network isolation (restrict DB user permissions and network access). If you need higher assurance, request the maintainer update the package metadata to declare required env vars and to stop overriding environment variables by default. If you want, I can list the exact lines in the code that implement the .env loading, the override behavior, and the import-time default reads so you can review or point them to the maintainer.
Capability Analysis
Type: OpenClaw Skill Name: sql-connector Version: 2.2.0 The sql-connector skill is a well-structured and legitimate SQL Server interface for OpenClaw agents. It demonstrates strong security practices, such as using a metaclass (_SealCoreMethods in sql_connector.py) to enforce parameterized queries and prevent SQL injection by sealing core execution methods. The code handles credentials safely via environment variables and includes comprehensive documentation and unit tests that align with its stated purpose.
Capability Assessment
Purpose & Capability
The skill's name/description match the included code: it implements an MSSQL connector using pymssql and exposes execute/query/scalar/ping. However the registry metadata claims 'Required env vars: none' while the docs and code clearly require SQL_* credentials (SQL_CLOUD_*, SQL_LOCAL_*, or SQL_{IDENT}_*). That mismatch is unexpected and should be clarified.
Instruction Scope
SKILL.md/GETTING_STARTED instruct the agent/user to create a .env in the OpenClaw workspace and to run health checks (ping/telnet). Instructions do not ask the agent to read unrelated system files or contact external endpoints. Minor inconsistency: docs direct the user to ~/.openclaw/workspace/.env, but the code's _find_env searches relative to the module path (walking up 5 dirs), so the documented .env location may not be discovered automatically.
Install Mechanism
No install spec is provided in the registry (instruction-only skill). README and GETTING_STARTED recommend pip install and a requirements.txt lists pymssql and python-dotenv — expected for a Python DB driver. No downloads from arbitrary URLs or extraction steps present.
Credentials
The connector legitimately needs SQL credentials, and the code reads them from environment/.env (SQL_* variables). However: (1) the registry metadata did not declare these required environment variables, (2) the module uses load_dotenv(..., override=True) which will overwrite existing environment variables with values from the discovered .env (surprising and potentially harmful), and (3) some defaults (e.g. _DEFAULT_BACKEND) are read at import time before .env is loaded, causing inconsistent behavior depending on how the module is imported. These environment-handling choices are disproportionate to what a user might expect and can lead to accidental credential exposure or config surprises.
Persistence & Privilege
The skill does not request always:true and does not modify other skills or system-wide settings. It loads .env lazily on first connector instantiation; it does not persist credentials itself. Autonomous invocation is allowed (platform default) which is expected for skills.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install sql-connector
  3. After installation, invoke the skill by name or use /sql-connector
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v2.2.0
GETTING_STARTED.md (494 lines) and SKILL_REFERENCE.md (712 lines) added. Publish workflow added. Custom backend naming documented. README updated with DEPENDENCY_PRIORITY.
v2.1.0
ping() method; SKILL.md cleanup
v2.1.0-alpha
Public alpha: rewrote README with pymssql API docs, sealed connector architecture, alpha warning, community invite.
v2.0.1
v2.0.1: pymssql transport, ABC sealed execute/query, get_connector factory, no sqlcmd
v2.0.0
v2.0: pymssql transport, ABC base, sealed execute/query, factory function — retires sqlcmd subprocess
Metadata
Slug sql-connector
Version 2.2.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 5
Frequently Asked Questions

What is SQL Connector?

Generic SQL Server connectivity for OpenClaw agents. Use when: (1) executing parameterized queries against SQL Server, (2) building repository layers that ne... It is an AI Agent Skill for Claude Code / OpenClaw, with 361 downloads so far.

How do I install SQL Connector?

Run "/install sql-connector" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is SQL Connector free?

Yes, SQL Connector is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does SQL Connector support?

SQL Connector is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created SQL Connector?

It is built and maintained by Oblio (@oblio-falootin); the current version is v2.2.0.

💬 Comments