mssql-mcp AGENTS.md

mssql-mcp AGENTS.md is an instructions file for Codex, OpenCode from eamonboyle/mssql-mcp. It costs 1,107 tokens per session, scanned A, original, MIT.

Project instructions for an MCP server that provides tools for querying and managing Microsoft SQL Server databases. MCP, or Model Context Protocol, is a standard way for AI agents to use external tools.

In plain words
What is it for?
Use it when building, linting, testing, starting, or running end-to-end checks for the mssql-mcp project.
Why use it?
It tells coding agents which commands validate the Node.js and TypeScript project and which tests require Docker and a live SQL Server.

Instructions file for CodexOpenCode

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add instructions/eamonboyle/mssql-mcp/agents-md
Clone the repo
git clone --depth 1 https://github.com/eamonboyle/mssql-mcp

Made for: Codex, OpenCode.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for mssql-mcp AGENTS.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/eamonboyle/mssql-mcp/agents-md.svg)](https://agentmods.dev/instructions/eamonboyle/mssql-mcp/agents-md)
Your own site
<a href="https://agentmods.dev/instructions/eamonboyle/mssql-mcp/agents-md"><img src="https://agentmods.dev/badge/instructions/eamonboyle/mssql-mcp/agents-md.svg" alt="Measured on agentmods" height="20"></a>
Per session 1,107 This file is loaded in full into every session.
When invoked 1,107 The same file — it is already loaded in full.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.01107 $0.01107
Opus 5 $0.00553 $0.00553
Sonnet 5 $0.00221 $0.00221
Haiku 4.5 $0.00111 $0.00111

Measured 4d ago against content hash 608685a31963, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

mssql-mcp AGENTS.md scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

AGENTS.md · 54 lines

How it starts

The opening of the file, as written. The whole thing — 54 lines — stays where its author put it; the contents beside it link to each section on GitHub.

AGENTS.md

Cursor Cloud specific instructions

This repo is a single Node.js/TypeScript product: the MSSQL MCP Server (@eamonboyle/mssql-mcp). It is an MCP (Model Context Protocol) server that exposes tools/resources/prompts for querying and managing a Microsoft SQL Server database. There is no web UI. Standard commands (build, lint, test, start, watch) live in package.json and are documented in README.md / CONTRIBUTING.md.

Lint / test / build (no database required)

  • npm run build, npm run lint, npm test all pass with no external services — the unit tests mock the DB (see src/__tests__/). Use these for fast validation.
  • The prepare script runs npm run build automatically on npm install, so dist/ exists after install.

Full MCP tool E2E (Docker + SQL required)

After the database is up, run npm run test:e2e to exercise every registered MCP tool against AppDB / ReportingDB and print a per-tool PASS/FAIL report.

cp .env.example .env   # if needed
npm run db:up          # start Docker MSSQL + seed (skip if already healthy)
npm run test:e2e       # builds, starts HTTP server (ENABLE_DDL=true), runs all tools

Scripts: scripts/e2e-mcp-tools.sh (orchestrator) and scripts/e2e-mcp-tools.mjs (harness). Details: docs/dev-database.md.

Cloud agent checklist:

  1. Start Docker if needed (dockerd; use sg docker -c '...' when the socket requires the docker group).
  2. npm run db:up — if the volume is corrupt, npm run db:reset.
  3. npm run test:e2e — exit code 0 means all tools passed.
  4. Server log on failure: /tmp/mssql-mcp-e2e-server.log

Running the server end-to-end (needs a SQL Server)

Use the repo's Docker Compose stack (seeded AppDB + ReportingDB). Details: docs/dev-database.md.

cp .env.example .env   # if you do not already have a .env
npm run db:up          # starts mssql-mcp-dev, waits, applies docker/mssql/init/*.sql
npm start              # loads .env via dotenv (stdio). For HTTP: MCP_TRANSPORT=http npm start

Read the full file on GitHub · 54 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 4d ago First seen · 54 lines · 1,107 tokens per session scan A 608685a31963

Subscribe to this mod's changes

mssql-mcp AGENTS.md is an instructions file published in the GitHub repository eamonboyle/mssql-mcp (5 stars, last pushed 3d ago), licensed MIT. It adds 1,107 tokens to every session, about $0.0055 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.