sqldb-mcp-server: Instructions file for GitHub Copilot

.github/copilot-instructions.md

sqldb-mcp-server copilot-instructions.md is an instructions file for GitHub Copilot from akrym1582/sqldb-mcp-server. It costs 2,881 tokens per session, scanned A, original, MIT.

Project instructions for an MCP server that lets an AI agent read SQL databases. SQL is the language used to query databases, and this server supports Microsoft SQL Server, PostgreSQL, and MySQL.

In plain words
What is it for?
Running SELECT queries, listing tables, inspecting table structure and query plans, and exporting results as CSV or JSON.
Why use it?
They describe a read-only setup that blocks database changes while allowing structured inspection and query results.

Instructions file for GitHub Copilot

Written for GitHub Copilot: a Copilot instructions file.

This is akrym1582/sqldb-mcp-server's own configuration. It tells GitHub Copilot how to work on sqldb-mcp-server itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything sqldb-mcp-server configures →

Reuse

Borrowing it

Nothing to install: this file belongs to akrym1582/sqldb-mcp-server. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/akrym1582/sqldb-mcp-server/main/.github/copilot-instructions.md
Clone the repo
git clone --depth 1 https://github.com/akrym1582/sqldb-mcp-server

Made for: GitHub Copilot.

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 sqldb-mcp-server copilot-instructions.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/akrym1582/sqldb-mcp-server/copilot-instructions.svg)](https://agentmods.dev/instructions/akrym1582/sqldb-mcp-server/copilot-instructions)
Your own site
<a href="https://agentmods.dev/instructions/akrym1582/sqldb-mcp-server/copilot-instructions"><img src="https://agentmods.dev/badge/instructions/akrym1582/sqldb-mcp-server/copilot-instructions.svg" alt="Measured on agentmods" height="20"></a>
Per session 2,881 This file is loaded in full into every session.
When invoked 2,881 The same file — it is already loaded in full.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
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.1 $0.02881 $0.02881
Opus 5 $0.01440 $0.01440
Sonnet 5 $0.00576 $0.00576
Haiku 4.5 $0.00288 $0.00288

Measured 7d ago against content hash 7ebdc609b8d3, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

sqldb-mcp-server copilot-instructions.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 7d 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.

.github/copilot-instructions.md · 148 lines

How it starts

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

Copilot Instructions

アプリの概要

sqldb-mcp-server は、LLM(大規模言語モデル)が SQL データベースへ安全にアクセスするための MCP(Model Context Protocol)サーバーです。

主な目的は、LLM が自然言語の文脈でデータベースを「読む」ことを許可しながら、書き込み・破壊的操作を一切禁止することです。具体的には以下の機能を提供します。

  • クエリ実行:SELECT 文のみを許可し、ページネーション付きで結果を返す
  • テーブル一覧取得:データベース内のベーステーブルを列挙する
  • テーブル構造取得:カラム定義・インデックス・外部キー・制約・サイズ統計を返す
  • 実行計画取得:クエリを実行せずに推定コストを確認する
  • ファイルエクスポート:クエリ結果を CSV または JSON ファイルにストリーム出力する(行数制限なし)

結果はすべて LLM のトークン消費を最小化するコンパクトな列指向フォーマット(columns + rows 配列)で返します。


技術スタック

区分 名称 バージョン 用途
言語 TypeScript(strict モード) ^5.9.3 ソースコード全体
ランタイム Node.js / CommonJS 実行環境・モジュールシステム
プロトコル @modelcontextprotocol/sdk ^1.27.1 MCP サーバー実装・stdio トランスポート
DB ドライバ mssql ^12.2.1 Microsoft SQL Server 接続・コネクションプール
DB ドライバ pg + pg-cursor ^8 / ^2 PostgreSQL 接続・コネクションプール・カーソルストリーム
DB ドライバ mysql2 ^3 MySQL 接続・コネクションプール・ストリーム
SQL パース node-sql-parser ^5.4.0 AST ベースの SQL 検証(読み取り専用強制)。DB_TYPE に応じてダイアレクトを切り替え
バリデーション zod ^4.3.6 ツール入力スキーマの定義と検証
環境変数 dotenv ^17.3.1 .env ファイルの読み込み
テスト jest + ts-jest ^30.3.0 / ^29.4.6 ユニットテスト
ビルド tsc(TypeScript Compiler) ^5.9.3 src/dist/ へのトランスパイル

ディレクトリ構成

src/
├── mcp/
│   ├── server.ts          # エントリーポイント。MCP サーバーの起動・ツール登録・シグナルハンドリング
│   └── tools/             # ツール層。各 MCP ツールの入力検証・キャッシュ制御・結果整形
├── db/
│   ├── types.ts           # DB アダプターのインターフェース定義(queryStream を含む)
│   ├── index.ts           # ファクトリ関数(DB_TYPE 環境変数に応じたアダプター生成)
│   └── adapters/          # DB アダプター層。各 DB ドライバの実装(MSSQL / PostgreSQL / MySQL)
│       ├── mssql.ts       # Microsoft SQL Server 実装(mssql)
│       ├── postgresql.ts  # PostgreSQL 実装(pg + pg-cursor)
│       └── mysql.ts       # MySQL 実装(mysql2)
├── utils/                 # ユーティリティ層。SQL 検証・結果フォーマット・ページネーション・キャッシュ・エクスポート
└── __tests__/             # ユニットテスト(utils/ および tools/ の各モジュールに対応)

アーキテクチャ・設計指針

レイヤー構成

[ MCP サーバー層 ] server.ts
        ↓  ツール登録・呼び出し
[ ツール層 ]       tools/*.ts
        ↓  SQL 検証・キャッシュ・フォーマット
[ ユーティリティ層 ] utils/*.ts
        ↓  クエリ実行・スキーマ取得
[ DB アダプター層 ] db/adapters/*.ts
        ↓
[ 外部: SQL データベース ]

Read the full file on GitHub · 148 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. 7d ago First seen · 148 lines · 2,881 tokens per session scan A 7ebdc609b8d3

Subscribe to this mod's changes

sqldb-mcp-server copilot-instructions.md is an instructions file published in the GitHub repository akrym1582/sqldb-mcp-server (0 stars, last pushed 2mo ago), licensed MIT. It adds 2,881 tokens to every session, about $0.0144 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.

Related

Other instructions, from other repositories

codex AGENTS.md

AGENTS.md instructions for openai/codex, covering rust/codex-rs, the codex-core crate, code review rules, crate api surface and model visible context.

openai/codex · 5,182 tokens

vscode buildNext.instructions.md

Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).

microsoft/vscode · 6,785 tokens

next.js AGENTS.md

AGENTS.md instructions for vercel/next.js, covering next.js development guide, codebase structure, monorepo overview, core package: packages/next and other important packages.

vercel/next.js · 7,296 tokens

langchain AGENTS.md

AGENTS.md instructions for langchain-ai/langchain, covering global development guidelines for the langchain monorepo, corridor security analysis, project architecture and context, monorepo structure and development tools & commands.

langchain-ai/langchain · 4,469 tokens

vscode oss-third-party-notices.instructions.md

Instructions for microsoft/vscode, covering vs code oss third-party-notices pipeline, architecture, pipeline flow in ci, applying the notice (cutover) and fallback chain (never fail the build).

microsoft/vscode · 5,001 tokens

spec-kit AGENTS.md

AGENTS.md instructions for github/spec-kit, covering agents.md, about spec kit and specify, quickstart — add a new integration in 5 steps, integration architecture and integrationmanifest — file tracking.

github/spec-kit · 7,104 tokens