Bollard MCP
PYPI · BOLLARD-MCP · SCANNED SEP 20
An AI-powered, safe database access gateway built on the Model Context Protocol (MCP).
Available components
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security100
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- Runs hatchling.build at install time, a recognised native-build step with no shell scripting around it. View diagnostics → Pass
- 4 of 46 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency19
- Repository check failed: no source repository is declared. See how to fix → View diagnostics → Fail
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (AGPL-3.0-only).Pass
- Actively maintained (last published 62 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability84
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1861 tokens (~124/item across 15 items; 14 tools + 1 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management87
- Stability observed for 26 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "execute_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 16 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
How do I install the Bollard MCP server?
Bollard MCP runs locally as a PyPI package, launched with uvx bollard-mcp. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
pypi · bollard-mcp
claude mcp add imdeepaksingh-bollard-mcp -- uvx bollard-mcp
{
"mcpServers": {
"imdeepaksingh-bollard-mcp": {
"command": "uvx",
"args": [
"bollard-mcp"
]
}
}
} {
"servers": {
"imdeepaksingh-bollard-mcp": {
"command": "uvx",
"args": [
"bollard-mcp"
]
}
}
} codex mcp add imdeepaksingh-bollard-mcp -- uvx bollard-mcp
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"imdeepaksingh-bollard-mcp": {
"type": "local",
"command": [
"uvx",
"bollard-mcp"
],
"enabled": true
}
}
} openclaw mcp add imdeepaksingh-bollard-mcp --command uvx --arg bollard-mcp
mcp_servers:
imdeepaksingh-bollard-mcp:
command: "uvx"
args: ["bollard-mcp"] {
"McpServers": {
"imdeepaksingh-bollard-mcp": {
"Transport": "stdio",
"Command": "uvx",
"Arguments": [
"bollard-mcp"
]
}
}
} assistant mcp add imdeepaksingh-bollard-mcp -t stdio -c uvx -a bollard-mcp
{
"mcpServers": {
"imdeepaksingh-bollard-mcp": {
"command": "uvx",
"args": [
"bollard-mcp"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 20 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 18 Sept 26 −2
- Stability: pass → 0.80 functional
- 17 Sept 26 0
- Stability: 0.97 → pass security
- 16 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 93 to 97. That category is still filling its 30-day observation window: 28 days of observed history at the previous scan, 29 at this one. The score rises as the window fills, whether or not the server changes.
- 15 Sept 26 +15
- Malware scan: unverified → pass ▲ security
- 14 Sept 26 −15
- Malware scan: pass → unverified ▼ security
- 13 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 12 Sept 26 +15
- Malware scan: unverified → pass ▲ security
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 20 Sept 2026 · Analysed pypi/bollard-mcp@0.1.4
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | pypi |
Background: How many MCP packages publish verified provenance →
Install scripts 1 script
| Hook | Tier | Command |
|---|---|---|
| build_backend | allowlisted | hatchling.build |
Background: Why install scripts are a supply-chain risk →
Dependencies 46 packages
| Packages resolved | 46 |
|---|---|
| Stale | 4 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
connect_database Connect Database ~293
Connect to a database.
| Name | Type | Req | Description |
|---|---|---|---|
| alias | string | yes | Short name for this connection (e.g., 'prod', 'staging'). |
| connection_string | string | yes | Full database URL. PostgreSQL: postgresql://user:pass@host:5432/dbname MySQL: mysql://user:pass@host:3306/dbname SQLite: sqlite:///path/to/file.db MSSQL: mssql://user:pass@host:1433/dbn… |
| forbidden_tables | – | – | Tables to block access to. Supports wildcards: '*.passwords', 'auth.*', 'users_secrets' |
| max_rows | integer | – | Maximum rows returned by SELECT queries (auto-LIMIT). |
| mode | string | – | Permission mode — 'read_only' | 'read_write' | 'admin'. Default: 'read_only' (safest). |
| output_mode | string | – | Controls how query results are returned to the AI. 'smart' (default) — Full results for small queries; 10-row sample + column stats for large ones. 'raw' — Always return full ra… |
| save_credential | boolean | – | If True, saves to OS Keyring for future sessions. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
describe_table Describe Table ~81
Show full column definitions, types, constraints, and indexes for a table. Includes: column names, data types, nullable, primary key, unique, foreign keys. The editor AI reads this to understand the exact schema before generating queries.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| table_name | string | yes | Table to describe (exact name, case-sensitive). |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
disconnect Disconnect ~24
Disconnect from a database.
| Name | Type | Req | Description |
|---|---|---|---|
| alias | string | yes | The connection alias to disconnect. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
execute_query Execute Query ~102
Execute a SQL query through the risk-tiered safety pipeline.
| Name | Type | Req | Description |
|---|---|---|---|
| confirmation_phrase | – | – | Required for HIGH risk — typed phrase e.g. "confirm update 12000 rows". |
| confirmed | boolean | – | Required for write operations. |
| connection | string | yes | Database alias (from connect_database). |
| output_mode | – | – | Override the connection's default output mode. |
| pin | – | – | OS PIN for write authorization. |
| sql | string | yes | SQL statement to execute. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
get_corrections Get Corrections ~56
Return all logged corrections for a connection. The editor AI reads this via the bollard://corrections/{alias} MCP Resource automatically. Call this tool directly to inspect them.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
get_query_history Get Query History ~78
Return recent query history for a connection. Useful for the editor AI to understand what has been executed recently, especially when the user says "run that again" or "fix the last query."
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| last_n | integer | – | Number of recent queries to return (max 50, default 10). |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
get_sample_data Get Sample Data ~93
Preview a few rows from a table to understand its data shape. Useful for the editor AI to understand the actual values in the database before generating queries (e.g., what status values exist, date formats, etc.)
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| limit | integer | – | Number of rows to return (max 25, default 5). |
| table_name | string | yes | Table to sample. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
list_connections List Connections ~27
List all currently active database connections. Returns alias, dialect, permission mode, and connection time.
Input schema present but exposes no named parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
list_tables List Tables ~57
List all tables in the connected database with row counts and sizes. The editor AI uses this to understand the database structure before generating queries. Schema is served from cache when available.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias (from connect_database). |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
log_correction Log Correction ~183
Log a query correction for future AI context. When the editor AI generates a wrong query and the user corrects it, log the correction here. Bollard persists it and exposes it via the bollard://corrections/{alias} MCP Resource, so the AI automatically learns from past mistakes without the user repeating themselves.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| corrected_query | string | yes | The correct SQL (or empty if just a note). |
| note | string | yes | Plain English explanation of what was wrong and why. Examples: - "Exclude test accounts: email LIKE '%@test.com%'" - "Use created_at, not signup_date — signup_date is deprecated" - "active us… |
| original_query | string | yes | The incorrect SQL that was generated. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
preview_query Preview Query ~137
Dry-run a query through the full safety + intent pipeline. Returns: - Safety verdict (SAFE / BLOCKED with reason) - Intent analysis (interpreted intent, assumed filters, ambiguity warnings) - EXPLAIN cost estimate (PostgreSQL only) - Final SQL with auto-LIMIT applied For bare SELECT * queries on large tables, Bollard will automatically redirect to profile_table to give the AI richer context with fewer tokens. The editor AI should call this before execute_query for any non-trivial query.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias (from connect_database). |
| sql | string | yes | SQL statement to preview. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
profile_table Profile Table ~128
Generate a statistical profile of a database table. All aggregation is performed directly in the database via SQL queries. No rows are transferred to local memory. Returns a compact Markdown summary suitable for AI context (< 150 tokens overhead per column). Includes for every column: - Row count and null percentage - Distinct value count - Min / Max / Avg (numeric and date columns) - Top-5 value distribution for categorical columns (<= 100 distinct values)
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias (from connect_database). |
| table_name | string | yes | Name of the table to profile. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
reconnect_saved Reconnect Saved ~34
Reconnect to a previously saved connection from the OS Keyring.
| Name | Type | Req | Description |
|---|---|---|---|
| alias | string | yes | The saved connection alias to restore. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
refresh_schema Refresh Schema ~52
Force a schema cache refresh for a connection. Call this after CREATE TABLE, ALTER TABLE, or any DDL operation to ensure the AI has up-to-date schema context.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database alias. |
| Name | Type | Req | Description |
|---|---|---|---|
| result | string | yes | – |
No examples provided.
What is the Bollard MCP server?
Bollard MCP is listed in the public MCP registry as io.github.ImDeepaksingh/bollard-mcp. An AI-powered, safe database access gateway built on the Model Context Protocol (MCP). This page covers its PyPI package (bollard-mcp).
Is the Bollard MCP server safe to use?
Bollard MCP scores 78 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 2026. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the Bollard MCP server expose?
Bollard MCP exposes 14 tools: connect_database, disconnect, list_connections, reconnect_saved, list_tables, and 9 more. Their descriptions and schemas cost roughly 1,345 tokens of context every time the server is loaded.
Is the Bollard MCP server still maintained?
Bollard MCP is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the Bollard MCP server under?
Bollard MCP declares the AGPL-3.0-only licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.