{"id":"e0d1bf1f-7ff1-45f0-b6b5-23258fa2d5a3","entityType":"agent","slug":"clawhub-0xvespertine-mssql","name":"MSSQL","canonicalUrl":"https://www.xpersona.co/agent/clawhub-0xvespertine-mssql","canonicalPath":"/agent/clawhub-0xvespertine-mssql","generatedAt":"2026-10-11T08:42:22.972Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":null},"description":"Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S... Skill: MSSQL Owner: 0xvespertine Summary: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-04-04T16:57:41.465Z | user v1.0.2 — Declare required env vars in metadata - Added MSSQL_HOST, MSSQL_DB, MSSQL_USER, MSSQL_PASSWORD to requires.env - Fixes manifest/met","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 1.1K downloads reported by the source. Last updated 10/11/2026.","installCommand":"clawhub skill install s1741t73nrt7q2vnxcrxcxxtjh83hfew:mssql","sourceUrl":"https://clawhub.ai/0xvespertine/mssql","homepage":"https://clawhub.ai/0xvespertine/skills/mssql","primaryLinks":[{"label":"View on ClawHub","url":"https://clawhub.ai/0xvespertine/mssql","kind":"source"},{"label":"Homepage","url":"https://clawhub.ai/0xvespertine/skills/mssql","kind":"homepage"}],"safetyScore":84,"overallRank":62,"popularityScore":44,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S..."},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":null},"stars":null,"forks":null,"downloads":1134,"packageName":null,"latestVersion":"1.0.2","tractionLabel":"1.1K downloads"},"release":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":null},"lastUpdatedAt":"2026-10-11T06:27:03.003Z","lastCrawledAt":"2026-10-11T06:27:03.003Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-12T06:27:03.003Z","lastVerifiedAt":null,"highlights":[{"version":"1.0.2","createdAt":"2026-04-04T16:57:41.465Z","changelog":"v1.0.2 — Declare required env vars in metadata - Added MSSQL_HOST, MSSQL_DB, MSSQL_USER, MSSQL_PASSWORD to requires.env - Fixes manifest/metadata inconsistency flagged by ClawHub security scan","fileCount":6,"zipByteSize":5522},{"version":"1.0.1","createdAt":"2026-04-04T16:53:50.391Z","changelog":"v1.0.1 — Security hardening + contract fix - Password no longer exposed in process list (uses SQLCMDPASSWORD env var) - MSSQL_TRUST_CERT defaults to no (certificate validation enabled) - Output contract renamed to delimiter-separated text (not CSV) — docs, examples, and help text updated - Fixed --out crash with filename-only paths - Fixed separator line removal — now position-aware (line 2 only) - Added --db flag for ad-hoc database override","fileCount":5,"zipByteSize":4258},{"version":"1.0.0","createdAt":"2026-03-23T08:51:26.059Z","changelog":"Initial release — SQL Server queries and CSV export, no query restrictions, permissions at DB user level","fileCount":5,"zipByteSize":3737}]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install s1741t73nrt7q2vnxcrxcxxtjh83hfew:mssql","setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-11T08:42:22.972Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-0xvespertine-mssql/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":null},"readme":"Skill: MSSQL\n\nOwner: 0xvespertine\n\nSummary: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S...\n\nTags: latest:1.0.2\n\nVersion history:\n\nv1.0.2 | 2026-04-04T16:57:41.465Z | user\n\nv1.0.2 — Declare required env vars in metadata\n\n- Added MSSQL_HOST, MSSQL_DB, MSSQL_USER, MSSQL_PASSWORD to requires.env\n- Fixes manifest/metadata inconsistency flagged by ClawHub security scan\n\nv1.0.1 | 2026-04-04T16:53:50.391Z | user\n\nv1.0.1 — Security hardening + contract fix\n\n- Password no longer exposed in process list (uses SQLCMDPASSWORD env var)\n- MSSQL_TRUST_CERT defaults to no (certificate validation enabled)\n- Output contract renamed to delimiter-separated text (not CSV) — docs, examples, and help text updated\n- Fixed --out crash with filename-only paths\n- Fixed separator line removal — now position-aware (line 2 only)\n- Added --db flag for ad-hoc database override\n\nv1.0.0 | 2026-03-23T08:51:26.059Z | user\n\nInitial release — SQL Server queries and CSV export, no query restrictions, permissions at DB user level\n\nArchive index:\n\nArchive v1.0.2: 6 files, 5522 bytes\n\nFiles: credentials/mssql.example.env (422b), references/DB_MAP.example.md (642b), scripts/mssql_query.sh (3052b), skill-card.md (2192b), SKILL.md (2989b), _meta.json (124b)\n\nFile v1.0.2:SKILL.md\n\n---\nname: mssql\nversion: 1.0.2\ndescription: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL Server, validate BI/reporting numbers, or prepare datasets for charts.\nmetadata: { \"openclaw\": { \"emoji\": \"DB\", \"requires\": { \"bins\": [\"sqlcmd\"], \"env\": [\"MSSQL_HOST\", \"MSSQL_DB\", \"MSSQL_USER\", \"MSSQL_PASSWORD\"] } } }\n---\n\n# MSSQL\n\nRun SQL Server queries using `scripts/mssql_query.sh`.\n\n## Quick start\n\n1. Ensure credentials exist at:\n   `~/.openclaw/credentials/mssql.env`\n2. Run a query:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 20 name FROM sys.tables\"`\n3. Save to file:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 100 * FROM dbo.MyTable\" --out /tmp/mytable.dsv`\n\n## Credentials format\n\nExpected env vars in `~/.openclaw/credentials/mssql.env`:\n\n- `MSSQL_HOST`\n- `MSSQL_DB`\n- `MSSQL_USER`\n- `MSSQL_PASSWORD`\n- Optional: `MSSQL_PORT` (default `1433`), `MSSQL_ENCRYPT` (`yes`/`no`, default `yes`), `MSSQL_TRUST_CERT` (`yes`/`no`, default `no`), `SQLCMD_BIN`\n\nThe credential file path can be overridden with the `MSSQL_ENV_FILE` environment variable.\n\n## Permissions\n\nQuery permissions are controlled entirely at the SQL Server user level. The script does not impose any restrictions on query type — the database user's grants determine what is allowed.\n\n## Database reference map\n\nPlace your database map at `references/DB_MAP.md` inside this skill folder. This file tells the agent which databases, schemas, and tables to use and how they relate to each other.\n\nSee `references/DB_MAP.example.md` for the expected format.\n\n## Useful patterns\n\n- Run long query from file:\n  `bash skills/mssql/scripts/mssql_query.sh --file /path/query.sql --out /tmp/out.dsv`\n- Override database:\n  `bash skills/mssql/scripts/mssql_query.sh --db OtherDB --query \"SELECT TOP 10 * FROM dbo.Users\"`\n- Change delimiter:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --delim \",\"`\n- Increase timeout:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --timeout 180`\n\n## Output format\n\nOutput is **delimiter-separated text**, not RFC 4180 CSV. Fields are not quoted or escaped. This works well for structured numeric and short-text data. If your columns contain embedded delimiters, quotes, or newlines, the output may be malformed — choose a delimiter that does not appear in the data, or post-process the output.\n\n## Best practices\n\n- Prefer explicit columns over `SELECT *`.\n- Use `TOP` for exploratory samples.\n- Keep queries scoped to the user request.\n- Answer in business language by default; provide SQL details when requested.\n- Never print or expose credentials in responses.\n\n## Troubleshooting\n\n- `sqlcmd not found` -> install sqlcmd v18+ or set `SQLCMD_BIN`.\n- TLS/certificate issues on internal networks -> set `MSSQL_TRUST_CERT=yes` in your credentials file. The default is `no` (certificate validation enabled).\n\nFile v1.0.2:_meta.json\n\n{\n  \"ownerId\": \"kn71mmn1vst817r9622exn54vn83fw03\",\n  \"slug\": \"mssql\",\n  \"version\": \"1.0.2\",\n  \"publishedAt\": 1775321861465\n}\n\nFile v1.0.2:references/DB_MAP.example.md\n\n# DB MAP - YOUR_DATABASE_NAME\n\n## Architecture\n- Source database: `YOUR_SOURCE_DB` (description of role)\n- Working database: `YOUR_WORKING_DB`\n- `schema_a.*` = description of schema A\n- `schema_b.*` = description of schema B\n- `dbo.*` = final business-ready tables for reporting and analysis\n\n## Tables to use\n- `dbo.customers`\n- `dbo.orders`\n- `dbo.products`\n- `dbo.invoices`\n- `dbo.payments`\n- `dbo.stock`\n\n## Usage rules\n- For routine business queries, use the final tables listed above first.\n- Use other schemas only when debugging or when the final tables do not cover the need.\n- Permissions are controlled at the database user level.\n\nFile v1.0.2:skill-card.md\n\n## Description:\n\nExecute SQL Server queries and export results as delimiter-separated text.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[0xvespertine](https://clawhub.ai/user/0xvespertine)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nDevelopers, data analysts, and agents use this skill to query Microsoft SQL Server, validate reporting numbers, manage data when authorized, and prepare database result sets for analysis or charts.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: The skill can run unrestricted SQL against the configured SQL Server according to the database user's grants.\n\nMitigation: Use a least-privilege SQL Server account, preferably read-only unless writes are required, and confirm insert, update, delete, schema, or administrative queries before execution.\n\nRisk: The skill loads credentials and the sqlcmd binary from the local environment.\n\nMitigation: Install only in a trusted environment, restrict the credential file, trust the selected sqlcmd binary, and never expose credentials in responses.\n\nRisk: Delimiter-separated output is not quoted or escaped, so embedded delimiters, quotes, or newlines can corrupt downstream parsing.\n\nMitigation: Choose a delimiter that does not appear in the data or post-process the output before using it in automated analysis.\n\n## Reference(s):\n\n- [DB_MAP.example.md](references/DB_MAP.example.md)\n- [ClawHub MSSQL skill page](https://clawhub.ai/0xvespertine/skills/mssql)\n\n## Skill Output:\n\n**Output Type(s):** [Text, Files, Shell commands, Configuration]\n\n**Output Format:** [Delimiter-separated text written to stdout or a .dsv file, with Markdown guidance for command usage]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Output is not RFC 4180 CSV; fields are not quoted or escaped.]\n\n## Skill Version(s):\n\n1.0.2 (source: frontmatter and server release evidence)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.\n\nArchive v1.0.1: 5 files, 4258 bytes\n\nFiles: credentials/mssql.example.env (422b), references/DB_MAP.example.md (642b), scripts/mssql_query.sh (3052b), SKILL.md (2922b), _meta.json (124b)\n\nFile v1.0.1:SKILL.md\n\n---\nname: mssql\nversion: 1.0.1\ndescription: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL Server, validate BI/reporting numbers, or prepare datasets for charts.\nmetadata: { \"openclaw\": { \"emoji\": \"DB\", \"requires\": { \"bins\": [\"sqlcmd\"] } } }\n---\n\n# MSSQL\n\nRun SQL Server queries using `scripts/mssql_query.sh`.\n\n## Quick start\n\n1. Ensure credentials exist at:\n   `~/.openclaw/credentials/mssql.env`\n2. Run a query:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 20 name FROM sys.tables\"`\n3. Save to file:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 100 * FROM dbo.MyTable\" --out /tmp/mytable.dsv`\n\n## Credentials format\n\nExpected env vars in `~/.openclaw/credentials/mssql.env`:\n\n- `MSSQL_HOST`\n- `MSSQL_DB`\n- `MSSQL_USER`\n- `MSSQL_PASSWORD`\n- Optional: `MSSQL_PORT` (default `1433`), `MSSQL_ENCRYPT` (`yes`/`no`, default `yes`), `MSSQL_TRUST_CERT` (`yes`/`no`, default `no`), `SQLCMD_BIN`\n\nThe credential file path can be overridden with the `MSSQL_ENV_FILE` environment variable.\n\n## Permissions\n\nQuery permissions are controlled entirely at the SQL Server user level. The script does not impose any restrictions on query type — the database user's grants determine what is allowed.\n\n## Database reference map\n\nPlace your database map at `references/DB_MAP.md` inside this skill folder. This file tells the agent which databases, schemas, and tables to use and how they relate to each other.\n\nSee `references/DB_MAP.example.md` for the expected format.\n\n## Useful patterns\n\n- Run long query from file:\n  `bash skills/mssql/scripts/mssql_query.sh --file /path/query.sql --out /tmp/out.dsv`\n- Override database:\n  `bash skills/mssql/scripts/mssql_query.sh --db OtherDB --query \"SELECT TOP 10 * FROM dbo.Users\"`\n- Change delimiter:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --delim \",\"`\n- Increase timeout:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --timeout 180`\n\n## Output format\n\nOutput is **delimiter-separated text**, not RFC 4180 CSV. Fields are not quoted or escaped. This works well for structured numeric and short-text data. If your columns contain embedded delimiters, quotes, or newlines, the output may be malformed — choose a delimiter that does not appear in the data, or post-process the output.\n\n## Best practices\n\n- Prefer explicit columns over `SELECT *`.\n- Use `TOP` for exploratory samples.\n- Keep queries scoped to the user request.\n- Answer in business language by default; provide SQL details when requested.\n- Never print or expose credentials in responses.\n\n## Troubleshooting\n\n- `sqlcmd not found` -> install sqlcmd v18+ or set `SQLCMD_BIN`.\n- TLS/certificate issues on internal networks -> set `MSSQL_TRUST_CERT=yes` in your credentials file. The default is `no` (certificate validation enabled).\n\nFile v1.0.1:_meta.json\n\n{\n  \"ownerId\": \"kn71mmn1vst817r9622exn54vn83fw03\",\n  \"slug\": \"mssql\",\n  \"version\": \"1.0.1\",\n  \"publishedAt\": 1775321630391\n}\n\nFile v1.0.1:references/DB_MAP.example.md\n\n# DB MAP - YOUR_DATABASE_NAME\n\n## Architecture\n- Source database: `YOUR_SOURCE_DB` (description of role)\n- Working database: `YOUR_WORKING_DB`\n- `schema_a.*` = description of schema A\n- `schema_b.*` = description of schema B\n- `dbo.*` = final business-ready tables for reporting and analysis\n\n## Tables to use\n- `dbo.customers`\n- `dbo.orders`\n- `dbo.products`\n- `dbo.invoices`\n- `dbo.payments`\n- `dbo.stock`\n\n## Usage rules\n- For routine business queries, use the final tables listed above first.\n- Use other schemas only when debugging or when the final tables do not cover the need.\n- Permissions are controlled at the database user level.\n\nArchive v1.0.0: 5 files, 3737 bytes\n\nFiles: credentials/mssql.example.env (422b), references/DB_MAP.example.md (642b), scripts/mssql_query.sh (2482b), SKILL.md (2365b), _meta.json (124b)\n\nFile v1.0.0:SKILL.md\n\n---\nname: mssql\nversion: 1.0.0\ndescription: Execute SQL Server queries and export results as CSV. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL Server, validate BI/reporting numbers, or prepare CSV datasets for charts.\nmetadata: { \"openclaw\": { \"emoji\": \"DB\", \"requires\": { \"bins\": [\"sqlcmd\"] } } }\n---\n\n# MSSQL\n\nRun SQL Server queries using `scripts/mssql_query.sh`.\n\n## Quick start\n\n1. Ensure credentials exist at:\n   `~/.openclaw/credentials/mssql.env`\n2. Run a query:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 20 name FROM sys.tables\"`\n3. Save to CSV:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 100 * FROM dbo.MyTable\" --out /tmp/mytable.csv`\n\n## Credentials format\n\nExpected env vars in `~/.openclaw/credentials/mssql.env`:\n\n- `MSSQL_HOST`\n- `MSSQL_DB`\n- `MSSQL_USER`\n- `MSSQL_PASSWORD`\n- Optional: `MSSQL_PORT` (default `1433`), `MSSQL_ENCRYPT` (`yes`/`no`), `MSSQL_TRUST_CERT` (`yes`/`no`), `SQLCMD_BIN`\n\nThe credential file path can be overridden with the `MSSQL_ENV_FILE` environment variable.\n\n## Permissions\n\nQuery permissions are controlled entirely at the SQL Server user level. The script does not impose any restrictions on query type — the database user's grants determine what is allowed.\n\n## Database reference map\n\nPlace your database map at `references/DB_MAP.md` inside this skill folder. This file tells the agent which databases, schemas, and tables to use and how they relate to each other.\n\nSee `references/DB_MAP.example.md` for the expected format.\n\n## Useful patterns\n\n- Run long query from file:\n  `bash skills/mssql/scripts/mssql_query.sh --file /path/query.sql --out /tmp/out.csv`\n- Change delimiter:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --delim \",\"`\n- Increase timeout:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --timeout 180`\n\n## Best practices\n\n- Prefer explicit columns over `SELECT *`.\n- Use `TOP` for exploratory samples.\n- Keep queries scoped to the user request.\n- Answer in business language by default; provide SQL details when requested.\n- Never print or expose credentials in responses.\n\n## Troubleshooting\n\n- `sqlcmd not found` -> install sqlcmd v18+ or set `SQLCMD_BIN`.\n- TLS/certificate issues on internal networks -> keep `MSSQL_ENCRYPT=yes` and set `MSSQL_TRUST_CERT=yes` if needed.\n\nFile v1.0.0:_meta.json\n\n{\n  \"ownerId\": \"kn71mmn1vst817r9622exn54vn83fw03\",\n  \"slug\": \"mssql\",\n  \"version\": \"1.0.0\",\n  \"publishedAt\": 1774255886059\n}\n\nFile v1.0.0:references/DB_MAP.example.md\n\n# DB MAP - YOUR_DATABASE_NAME\n\n## Architecture\n- Source database: `YOUR_SOURCE_DB` (description of role)\n- Working database: `YOUR_WORKING_DB`\n- `schema_a.*` = description of schema A\n- `schema_b.*` = description of schema B\n- `dbo.*` = final business-ready tables for reporting and analysis\n\n## Tables to use\n- `dbo.customers`\n- `dbo.orders`\n- `dbo.products`\n- `dbo.invoices`\n- `dbo.payments`\n- `dbo.stock`\n\n## Usage rules\n- For routine business queries, use the final tables listed above first.\n- Use other schemas only when debugging or when the final tables do not cover the need.\n- Permissions are controlled at the database user level.","readmeExcerpt":"Skill: MSSQL Owner: 0xvespertine Summary: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-04-04T16:57:41.465Z | user v1.0.2 — Declare required env vars in metadata - Added MSSQL_HOST, MSSQL_DB, MSSQL_USER, MSSQL_PASSWORD to requires.env - Fixes manifest/met","codeSnippets":[],"executableExamples":[],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[{"path":"SKILL.md","content":"---\nname: mssql\nversion: 1.0.2\ndescription: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL Server, validate BI/reporting numbers, or prepare datasets for charts.\nmetadata: { \"openclaw\": { \"emoji\": \"DB\", \"requires\": { \"bins\": [\"sqlcmd\"], \"env\": [\"MSSQL_HOST\", \"MSSQL_DB\", \"MSSQL_USER\", \"MSSQL_PASSWORD\"] } } }\n---\n\n# MSSQL\n\nRun SQL Server queries using `scripts/mssql_query.sh`.\n\n## Quick start\n\n1. Ensure credentials exist at:\n   `~/.openclaw/credentials/mssql.env`\n2. Run a query:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 20 name FROM sys.tables\"`\n3. Save to file:\n   `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT TOP 100 * FROM dbo.MyTable\" --out /tmp/mytable.dsv`\n\n## Credentials format\n\nExpected env vars in `~/.openclaw/credentials/mssql.env`:\n\n- `MSSQL_HOST`\n- `MSSQL_DB`\n- `MSSQL_USER`\n- `MSSQL_PASSWORD`\n- Optional: `MSSQL_PORT` (default `1433`), `MSSQL_ENCRYPT` (`yes`/`no`, default `yes`), `MSSQL_TRUST_CERT` (`yes`/`no`, default `no`), `SQLCMD_BIN`\n\nThe credential file path can be overridden with the `MSSQL_ENV_FILE` environment variable.\n\n## Permissions\n\nQuery permissions are controlled entirely at the SQL Server user level. The script does not impose any restrictions on query type — the database user's grants determine what is allowed.\n\n## Database reference map\n\nPlace your database map at `references/DB_MAP.md` inside this skill folder. This file tells the agent which databases, schemas, and tables to use and how they relate to each other.\n\nSee `references/DB_MAP.example.md` for the expected format.\n\n## Useful patterns\n\n- Run long query from file:\n  `bash skills/mssql/scripts/mssql_query.sh --file /path/query.sql --out /tmp/out.dsv`\n- Override database:\n  `bash skills/mssql/scripts/mssql_query.sh --db OtherDB --query \"SELECT TOP 10 * FROM dbo.Users\"`\n- Change delimiter:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --delim \",\"`\n- Increase timeout:\n  `bash skills/mssql/scripts/mssql_query.sh --query \"SELECT ...\" --timeout 180`\n\n## Output format\n\nOutput is **delimiter-separated text**, not RFC 4180 CSV. Fields are not quoted or escaped. This works well for structured numeric and short-text data. If your columns contain embedded delimiters, quotes, or newlines, the output may be malformed — choose a delimiter that does not appear in the data, or post-process the output.\n\n## Best practices\n\n- Prefer explicit columns over `SELECT *`.\n- Use `TOP` for exploratory samples.\n- Keep queries scoped to the user request.\n- Answer in business language by default; provide SQL details when requested.\n- Never print or expose credentials in responses.\n\n## Troubleshooting\n\n- `sqlcmd not found` -> install sqlcmd v18+ or set `SQLCMD_BIN`.\n- TLS/certificate issues on internal networks -> set `MSSQL_TRUST_CERT=yes` in your credentials file. The default is `no` (certificate validation enabled)."},{"path":"_meta.json","content":"{\n  \"ownerId\": \"kn71mmn1vst817r9622exn54vn83fw03\",\n  \"slug\": \"mssql\",\n  \"version\": \"1.0.2\",\n  \"publishedAt\": 1775321861465\n}"},{"path":"references/DB_MAP.example.md","content":"# DB MAP - YOUR_DATABASE_NAME\n\n## Architecture\n- Source database: `YOUR_SOURCE_DB` (description of role)\n- Working database: `YOUR_WORKING_DB`\n- `schema_a.*` = description of schema A\n- `schema_b.*` = description of schema B\n- `dbo.*` = final business-ready tables for reporting and analysis\n\n## Tables to use\n- `dbo.customers`\n- `dbo.orders`\n- `dbo.products`\n- `dbo.invoices`\n- `dbo.payments`\n- `dbo.stock`\n\n## Usage rules\n- For routine business queries, use the final tables listed above first.\n- Use other schemas only when debugging or when the final tables do not cover the need.\n- Permissions are controlled at the database user level."},{"path":"skill-card.md","content":"## Description:\n\nExecute SQL Server queries and export results as delimiter-separated text.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[0xvespertine](https://clawhub.ai/user/0xvespertine)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nDevelopers, data analysts, and agents use this skill to query Microsoft SQL Server, validate reporting numbers, manage data when authorized, and prepare database result sets for analysis or charts.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: The skill can run unrestricted SQL against the configured SQL Server according to the database user's grants.\n\nMitigation: Use a least-privilege SQL Server account, preferably read-only unless writes are required, and confirm insert, update, delete, schema, or administrative queries before execution.\n\nRisk: The skill loads credentials and the sqlcmd binary from the local environment.\n\nMitigation: Install only in a trusted environment, restrict the credential file, trust the selected sqlcmd binary, and never expose credentials in responses.\n\nRisk: Delimiter-separated output is not quoted or escaped, so embedded delimiters, quotes, or newlines can corrupt downstream parsing.\n\nMitigation: Choose a delimiter that does not appear in the data or post-process the output before using it in automated analysis.\n\n## Reference(s):\n\n- [DB_MAP.example.md](references/DB_MAP.example.md)\n- [ClawHub MSSQL skill page](https://clawhub.ai/0xvespertine/skills/mssql)\n\n## Skill Output:\n\n**Output Type(s):** [Text, Files, Shell commands, Configuration]\n\n**Output Format:** [Delimiter-separated text written to stdout or a .dsv file, with Markdown guidance for command usage]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Output is not RFC 4180 CSV; fields are not quoted or escaped.]\n\n## Skill Version(s):\n\n1.0.2 (source: frontmatter and server release evidence)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment."}],"languages":[],"docsSourceLabel":"CLAWHUB","editorialOverview":"Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S... Skill: MSSQL Owner: 0xvespertine Summary: Execute SQL Server queries and export results as delimiter-separated text. Use when the user asks to fetch, insert, update, or manage data in Microsoft SQL S... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-04-04T16:57:41.465Z | user v1.0.2 — Declare required env vars in metadata - Added MSSQL_HOST, MSSQL_DB, MSSQL_USER, MSSQL_PASSWORD to requires.env - Fixes manifest/met","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":1300,"uniquenessScore":45,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-10-11T06:27:03.003Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-11T08:42:22.972Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}