What is dremio-mcp-lite copilot-instructions.md?

Project instructions for a TypeScript MCP server that lets AI assistants run read-only data exploration queries against Dremio databases. Dremio is a platform for querying data from different sources.

Use it when developing or testing the Dremio MCP server and when checking that database operations cannot modify data.

It tells coding agents how the project is organized, built, run, and secured, including that only SELECT queries are allowed.

How guillaume-galp/dremio-mcp-lite configures GitHub Copilot

Reuse

Borrowing it

Nothing to install: this file belongs to guillaume-galp/dremio-mcp-lite. 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/guillaume-galp/dremio-mcp-lite/main/.github/copilot-instructions.md

Clone the repo

git clone --depth 1 https://github.com/guillaume-galp/dremio-mcp-lite

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.

README.md

[![agentmods](https://agentmods.dev/badge/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions/github.svg)](https://agentmods.dev/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions)

Your own site

<a href="https://agentmods.dev/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions"><img src="https://agentmods.dev/badge/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions"><img src="https://agentmods.dev/badge/instructions/guillaume-galp/dremio-mcp-lite/copilot-instructions.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 1,143 This file is loaded in full into every session.

When invoked 1,143 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.

Model	Per session	Once invoked
Fable 5.1	$0.01143	$0.01143
Opus 5	$0.00571	$0.00571
Sonnet 5	$0.00229	$0.00229
Haiku 4.5	$0.00114	$0.00114

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

Security

Grade A, and why

dremio-mcp-lite 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 10d 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 · 140 lines

How it starts

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

Copilot Instructions for dremio-mcp-lite

Project Overview

This is a TypeScript MCP (Model Context Protocol) server for Dremio data exploration. The project provides read-only operations for AI assistants to interact with Dremio databases.

Key characteristics:

TypeScript with ES modules
MCP server using @modelcontextprotocol/sdk
Read-only SQL operations for security
Optimized for fast startup (<1s)
No testing infrastructure currently exists

Project Structure

/src
  ├── index.ts           # Main MCP server setup and tool handlers
  └── dremio-client.ts   # Dremio API client and SQL utilities

Build and Development Commands

Build: npm run build - Compiles TypeScript to /build directory
Run locally: npm start - Runs the built server
Prepare: npm run prepare - Auto-runs build (triggered by npm)

Important: Always run npm run build after code changes before testing.

Security Practices

This project has strict security requirements:

Read-Only SQL Queries: Only SELECT statements are allowed
- The isSelectQuery() function validates SQL queries
- Removes SQL comments before validation to prevent bypass attempts
- All modifications (INSERT, UPDATE, DELETE, DROP, etc.) must be blocked
SQL Injection Protection:
- Use escapeIdentifier() method for table/column identifiers
- Wraps identifiers in double quotes and escapes existing quotes
- Never concatenate user input directly into SQL queries
Credential Management:
- Dremio PAT (Personal Access Token) stored in .env file
- Never commit .env file to version control
- Always use .env.example as template
Query Validation:
- Validate queries handle comments (-- and /* */)
- Validate queries handle leading/trailing whitespace
- Ensure isSelectQuery() cannot be bypassed

Code Style and Conventions

TypeScript: Use strict typing, avoid any where possible
ES Modules: Use .js extensions in imports (e.g., './dremio-client.js')
Error Handling: Return structured error responses with isError: true
Async/Await: Prefer async/await over promises
Comments: Minimal comments, use JSDoc for public APIs
No Testing: Do not add testing infrastructure unless explicitly requested

Read the full file on GitHub · 140 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.

10d ago First seen · 140 lines · 1,143 tokens per session scan A 84600e69eff4

Subscribe to this mod's changes

dremio-mcp-lite copilot-instructions.md is an instructions file published in the GitHub repository guillaume-galp/dremio-mcp-lite (0 stars, last pushed 7mo ago), licensed MIT. It adds 1,143 tokens to every session, about $0.0057 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.

Databases

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

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,153 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

dremio-mcp-lite: Instructions file for GitHub Copilot