io.github.cocaxcode/database-mcp

NPM · @COCAXCODE/DATABASE-MCP · SCANNED AUG 4

MCP server for database connectivity. Multi-DB (PostgreSQL, MySQL, SQLite), 19 tools.

Available components

+17 this week 70 70 Trust /100

Trust breakdown (6 categories)

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 →

Supply Chain Security83

No malware found by supply-chain analysis.Pass
CVE check failed: a known medium-severity CVE affects hono 4.12.33, reached via @modelcontextprotocol/sdk > hono. A fixed version is available. View diagnostics → Fail
No install/post-install scripts declared.Pass
Only part of the dependency tree could be resolved (105 of 109), so this covers what we could see, not the whole tree. View diagnostics → Partial

Provenance & Transparency45

Source repository is publicly reachable at the declared URL. View diagnostics → Pass
Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
Clear OSI-approved license (MIT).Pass
Actively maintained (last published 104 days ago).Pass
Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail

Schema Quality & AI Usability83

100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
AI-judged instruction clarity (good).Pass
Tool/resource definitions use about 1854 tokens (~68/item across 27 items; 26 tools + 1 resources), lean.Pass
Usage-examples check failed: none of the tools include examples. See how to fix → Fail

Stability & Change Management30

Stability observed for 9 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

Capabilities100

Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass

Install

Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.

npm · @cocaxcode/database-mcp

Claude Codex opencode OpenClaw Hermes Other

# add to Claude Code

claude mcp add cocaxcode-database-mcp -- npx -y @cocaxcode/database-mcp

# add to Codex CLI

codex mcp add cocaxcode-database-mcp -- npx -y @cocaxcode/database-mcp

// opencode.json

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "cocaxcode-database-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "@cocaxcode/database-mcp"
      ],
      "enabled": true
    }
  }
}

# add to OpenClaw

openclaw mcp add cocaxcode-database-mcp --command npx --arg -y --arg @cocaxcode/database-mcp

# ~/.hermes/config.yaml

mcp_servers:
  cocaxcode-database-mcp:
    command: "npx"
    args: ["-y", "@cocaxcode/database-mcp"]

// mcp.json

{
  "mcpServers": {
    "cocaxcode-database-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@cocaxcode/database-mcp"
      ]
    }
  }
}

Changelog

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.

4 Aug 26 −1
- CVE-2026-69207 affects this package: medium ▼ security
- Known CVEs: partial → fail ▼ security
3 Aug 26 +4
- Stability: unverified → 0.27 ▲ functional
2 Aug 26 +7
- Install scripts: pass → unverified ▼ security
- Provenance: fail → unverified ▼ security
- Known CVEs: unverified → partial ▲ security
- Maintenance: pass → unverified ▼ functional
- License: pass → unverified ▼ functional
- Dependency health: unverified → partial ▲ functional
- Licence: MIT functional
1 Aug 26 −10
- Known CVEs: partial → unverified ▼ security
- Dependency health: partial → unverified ▼ functional
31 Jul 26 +19
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
30 Jul 26 −30
- Malware scan: pass → unverified ▼ security
- Known CVEs: partial → unverified ▼ security
- Dependency health: partial → unverified ▼ functional
29 Jul 26 +28
- Provenance: unverified → fail ▼ security
- Known CVEs: unverified → partial ▲ security
- Install scripts: unverified → pass ▲ security
- Dependency health: unverified → partial ▲ functional
- License: unverified → pass ▲ functional
- Schema quality: unverified → good ▲ functional
- Maintenance: unverified → pass ▲ functional
- Licence: MIT functional
27 Jul 26 53

First indexed and scored.

Show 3 earlier entries Hide earlier entries

Diagnostics

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 4 Aug 2026 · Analysed npm/@cocaxcode/[email protected]

Provenance none

Ecosystem: npm · Outcome: none

Vulnerabilities 1 finding

ID	CVE	Severity	Vector	Fix available
GHSA-8j4g-w8fx-2239	CVE-2026-69207	medium	CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:L	yes

Dependencies 105 packages

105 packages in the resolved dependency tree · 105 deprecated · 32 stale.

The dependency tree was only partially resolved, so these counts may be incomplete.

MCP tools — 26 exposed · ~1,620 tokens

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.

Tool Tokens

config_get ~24

Muestra la configuracion actual del servidor (limites de rollback e historial).

Input Output Examples

Input schema present but exposes no named parameters.

No output schema declared.

No examples provided.

config_set ~69

Modifica la configuracion del servidor. Los cambios se guardan permanentemente.

Input Output Examples

Name	Type	Req	Description
max_history	number	—	Maximo de entradas de historial por proyecto (default: 5000)
max_rollbacks	number	—	Maximo de snapshots de rollback por proyecto (default: 1000)

No output schema declared.

No examples provided.

conn_create ~166

Crea una nueva conexion a base de datos (PostgreSQL, MySQL o SQLite).

Input Output Examples

Name	Type	Req	Description
database	string	—	Nombre de la base de datos
dsn	string	—	Connection string completo (ej: postgresql://user:pass@host:5432/db)
filepath	string	—	Ruta al archivo SQLite (omitir para :memory:)
host	string	—	Host del servidor
mode	string	—	Modo de acceso (default: read-only)
name	string	yes	Nombre de la conexion (ej: local-pg, staging-mysql)
password	string	—	Password
port	number	—	Puerto
type	string	yes	Tipo de base de datos
user	string	—	Usuario

No output schema declared.

No examples provided.

conn_delete ~65

Elimina una conexion. IMPORTANTE: pide confirmacion al usuario antes de llamar esta tool con confirm=true.

Input Output Examples

Name	Type	Req	Description
confirm	boolean	—	Debe ser true para confirmar. Pregunta al usuario antes de poner true.
name	string	yes	Nombre de la conexion a eliminar

No output schema declared.

No examples provided.

conn_duplicate ~44

Duplica una conexion existente con un nuevo nombre.

Input Output Examples

Name	Type	Req	Description
name	string	yes	Nombre de la conexion a duplicar
new_name	string	yes	Nombre para la copia

No output schema declared.

No examples provided.

conn_export ~70

Exporta conexiones a JSON. Por defecto enmascara passwords — usa include_secrets=true para incluirlos.

Input Output Examples

Name	Type	Req	Description
include_secrets	boolean	—	Incluir passwords y DSNs sin enmascarar
name	string	—	Nombre de una conexion especifica (omitir para exportar todas)

No output schema declared.

No examples provided.

conn_get ~36

Obtiene los detalles de una conexion. El password se muestra enmascarado.

Input Output Examples

Name	Type	Req	Description
name	string	yes	Nombre de la conexion

No output schema declared.

No examples provided.

conn_import ~66

Importa conexiones desde un JSON exportado. Omite conexiones que ya existen (usa overwrite=true para reemplazar).

Input Output Examples

Name	Type	Req	Description
json	string	yes	JSON con las conexiones a importar (formato de conn_export)
overwrite	boolean	—	Reemplazar conexiones existentes con el mismo nombre

No output schema declared.

No examples provided.

conn_list ~19

Lista todas las conexiones disponibles e indica cual esta activa.

Input Output Examples

Input schema present but exposes no named parameters.

No output schema declared.

No examples provided.

conn_project_clear ~32

Elimina la asociacion de conexion especifica de un proyecto.

Input Output Examples

Name	Type	Req	Description
project	string	yes	Ruta del proyecto

No output schema declared.

No examples provided.

conn_project_list ~20

Lista todos los proyectos con conexiones especificas asignadas.

Input Output Examples

Input schema present but exposes no named parameters.

No output schema declared.

No examples provided.

conn_rename ~37

Renombra una conexion existente.

Input Output Examples

Name	Type	Req	Description
name	string	yes	Nombre actual de la conexion
new_name	string	yes	Nuevo nombre

No output schema declared.

No examples provided.

conn_set ~64

Actualiza un campo de una conexion existente.

Input Output Examples

Name	Type	Req	Description
key	string	yes	Campo a actualizar (host, port, database, user, password, dsn, filepath, mode)
name	string	yes	Nombre de la conexion
value	string	yes	Nuevo valor

No output schema declared.

No examples provided.

conn_switch ~58

Cambia la conexion activa. Si se especifica project, solo aplica a ese directorio.

Input Output Examples

Name	Type	Req	Description
name	string	yes	Nombre de la conexion a activar
project	string	—	Ruta del proyecto (si se omite, cambia global)

No output schema declared.

No examples provided.

conn_test ~42

Prueba la conexion a una base de datos. Ejecuta SELECT 1 y mide la latencia.

Input Output Examples

Name	Type	Req	Description
name	string	yes	Nombre de la conexion a probar

No output schema declared.

No examples provided.

db_dump ~131

Exporta la base de datos a un archivo SQL. Flujo conversacional: primero pregunta si exportar todas las tablas o personalizar, luego que contenido incluir (estructura, datos o todo).

Input Output Examples

Name	Type	Req	Description
content	string	—	schema = solo estructura, data = solo datos, full = todo. Si no se pasa, pregunta.
schema	string	—	Schema de PostgreSQL (default: public)
scope	string	—	all = todas las tablas, custom = elegir tablas. Si no se pasa, pregunta.
tables	array	—	Tablas a exportar (solo cuando scope="custom").

No output schema declared.

No examples provided.

db_dump_list ~18

Lista los dumps disponibles en el proyecto actual.

Input Output Examples

Input schema present but exposes no named parameters.

No output schema declared.

No examples provided.

db_restore ~97

Restaura un dump SQL en la base de datos activa. IMPORTANTE: esta operacion es destructiva (DROP TABLE + CREATE TABLE). Pide confirmacion al usuario antes de ejecutar con confirm=true.

Input Output Examples

Name	Type	Req	Description
confirm	boolean	—	Debe ser true para confirmar. Pregunta al usuario antes.
filename	string	—	Nombre del archivo SQL a restaurar (de la carpeta dumps). Si no se pasa, lista los disponibles.

No output schema declared.

No examples provided.

execute_mutation ~58

Ejecuta una mutacion (INSERT, UPDATE, DELETE, DDL). Pide confirmacion y crea snapshot para rollback.

Input Output Examples

Name	Type	Req	Description
params	array	—	Parametros para prepared statement
sql	string	yes	Sentencia SQL de escritura

No output schema declared.

No examples provided.

execute_query ~66

Ejecuta una consulta de lectura (SELECT, SHOW, etc.). Inyecta LIMIT automaticamente.

Input Output Examples

Name	Type	Req	Description
limit	number	—	Limite de filas (default: 100)
params	array	—	Parametros para prepared statement
sql	string	yes	Consulta SQL de lectura

No output schema declared.

No examples provided.

explain_query ~70

Muestra el plan de ejecucion de una consulta (EXPLAIN). Sin ANALYZE por defecto.

Input Output Examples

Name	Type	Req	Description
analyze	boolean	—	Ejecutar ANALYZE (ojo: ejecuta la query realmente)
params	array	—	Parametros
sql	string	yes	Consulta SQL a analizar

No output schema declared.

No examples provided.

history_clear ~47

Limpia el historial de consultas. Opcionalmente solo las anteriores a una fecha.

Input Output Examples

Name	Type	Req	Description
before	string	—	Fecha ISO 8601. Si se especifica, solo elimina entradas anteriores

No output schema declared.

No examples provided.

history_list ~94

Lista el historial de consultas ejecutadas. Filtrable por tipo, conexion y estado.

Input Output Examples

Name	Type	Req	Description
connection	string	—	Filtrar por nombre de conexion
limit	number	—	Cantidad maxima de resultados (default: 20)
success	boolean	—	Filtrar por exito (true) o fallo (false)
type	string	—	Filtrar por tipo (read, write, ddl, explain)

No output schema declared.

No examples provided.

rollback_apply ~62

Revierte una mutacion usando un rollback snapshot. IMPORTANTE: confirma con el usuario antes de ejecutar con confirm=true.

Input Output Examples

Name	Type	Req	Description
confirm	boolean	—	Debe ser true para confirmar. Pregunta al usuario antes.
id	string	yes	ID del rollback snapshot

No output schema declared.

No examples provided.

rollback_list ~56

Lista los rollback snapshots disponibles. Muestra las mutaciones recientes que se pueden revertir.

Input Output Examples

Name	Type	Req	Description
connection	string	—	Filtrar por nombre de conexion
limit	number	—	Cantidad maxima de resultados (default: 20)

No output schema declared.

No examples provided.

search_schema ~109

Busca tablas/vistas en el schema de la base de datos. Soporta 3 niveles de detalle: names (solo nombres), summary (nombres + columnas), full (todo + FK + indices).

Input Output Examples

Name	Type	Req	Description
detail_level	string	—	Nivel de detalle
object_type	string	—	Tipo de objeto a buscar
pattern	string	—	Patron de busqueda (ej: "user%", "%order%")
schema	string	—	Schema (solo PostgreSQL, default: public)

No output schema declared.

No examples provided.

On this page

Handy links

Scoring key

80+ high trust
60–79 medium
below 60 low

How we score

Score history · last 30 days

27 Jul 4 Aug

Day	Score
27 Jul	53
28 Jul	53
29 Jul	81
30 Jul	51
31 Jul	70
1 Aug	60
2 Aug	67
3 Aug	71
4 Aug	70