# io.github.cybeleri/database-admin (npm · database-admin-mcp)

Database admin MCP: schema inspection, query optimization for PostgreSQL and MySQL

- Trust score: 61/100 (medium)
- Change this week: +43
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- npm · `database-admin-mcp`: 61/100 (this document), [markdown](https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp.md), [page](https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp)

## Channel facts

- Registry: `npm`
- Package: `database-admin-mcp`
- Version: `1.0.1`
- Transport: `stdio`

## Trust breakdown

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. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Supply Chain Security**: 87/100
  - No malware found by supply-chain analysis.
  - Only part of the dependency tree could be resolved (117 of 121), so this covers what we could see, not the whole tree.
  - No install/post-install scripts declared.
  - Only part of the dependency tree could be resolved (117 of 121), so this covers what we could see, not the whole tree.
- **Provenance & Transparency**: 19/100
  - Repository check failed: the declared repository URL returned HTTP 404.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 218 days ago).
  - Security-disclosure policy not yet verified: we couldn't inspect the source repository.
- **Schema Quality & AI Usability**: 81/100
  - 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).
  - AI-judged instruction clarity (good).
  - Tool/resource definitions use about 421 tokens (~42/item across 10 items; 9 tools + 1 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### Claude

```bash
claude mcp add cybeleri-database-admin -- npx -y database-admin-mcp
```

### Codex

```bash
codex mcp add cybeleri-database-admin -- npx -y database-admin-mcp
```

### opencode

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

### OpenClaw

```bash
openclaw mcp add cybeleri-database-admin --command npx --arg -y --arg database-admin-mcp
```

### Hermes

```yaml
mcp_servers:
  cybeleri-database-admin:
    command: "npx"
    args: ["-y", "database-admin-mcp"]
```

### Other

```json
{
  "mcpServers": {
    "cybeleri-database-admin": {
      "command": "npx",
      "args": [
        "-y",
        "database-admin-mcp"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-02 (score 61, +30)

- [security regression] Provenance: unverified → fail
- [security improvement] Malware scan: unverified → pass
- [security improvement] Install scripts: unverified → pass
- [security improvement] Known CVEs: unverified → partial
- [functional improvement] License: unverified → pass
- [functional improvement] Dependency health: unverified → partial
- [functional improvement] Maintenance: unverified → pass
- [functional] Licence: MIT

### 2026-08-01 (score 31, +10)

- [security] Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window).
- [functional improvement] MCP protocol: unverified → pass
- [functional improvement] Schema quality: unverified → good

### 2026-07-31 (score 21, +20)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-30 (score 1, −17)

- [security regression] Malware scan: pass → unverified
- [functional improvement] Dependency health: unverified → partial

### 2026-07-27 (score 18)

First indexed and scored.

## MCP tools (9)

### `list_tables` (~21 tokens)

List all tables in the database with their size and index count.

### `describe_table` (~59 tokens)

Get detailed schema information about a table including columns, types, indexes, and foreign keys.

Input parameters:

- `schema` (string): Schema name (PostgreSQL only, defaults to 'public')
- `tableName` (string, required): Name of the table to describe

### `sample_data` (~71 tokens)

Retrieve sample rows from a table to understand its data structure and content.

Input parameters:

- `limit` (number): Number of rows to return (default: 10, max: 1000)
- `schema` (string): Schema name (PostgreSQL only)
- `tableName` (string, required): Name of the table

### `execute_query` (~50 tokens)

Execute a SQL query and return results. By default, only SELECT queries are allowed (read-only mode). Set DB_READ_ONLY=false to enable write operations.

Input parameters:

- `query` (string, required): SQL query to execute

### `analyze_indexes` (~48 tokens)

Analyze table indexes for usage statistics, unused indexes, and optimization suggestions.

Input parameters:

- `schema` (string): Schema name (PostgreSQL only)
- `tableName` (string, required): Name of the table

### `explain_query` (~30 tokens)

Get query execution plan with cost estimates and optimization suggestions.

Input parameters:

- `query` (string, required): SQL query to analyze

### `generate_migration` (~86 tokens)

Generate SQL migration scripts for schema changes with up/down migrations.

Input parameters:

- `action` (string, required): Type of migration
- `details` (object, required): Migration details (columnName, columnType, nullable, default for columns; columns, unique, concurrent for indexes; column, referencesTable, referencesColumn, onDelete for foreign keys)
- `tableName` (string, required): Name of the table

### `get_relationships` (~24 tokens)

Get all foreign key relationships in the database as a graph showing table connections.

### `get_connection_info` (~18 tokens)

Get current database connection configuration and mode settings.

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp#diagnostics

## Score history

- 2026-08-03: 61
- 2026-08-02: 61
- 2026-08-01: 31
- 2026-07-31: 21
- 2026-07-30: 1
- 2026-07-28: 18
- 2026-07-27: 18

## Links

- npm package: https://www.npmjs.com/package/database-admin-mcp
- Socket report: https://socket.dev/npm/package/database-admin-mcp
- Changelog RSS feed: https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp/changelog.json
- HTML version of this page: https://verifymcp.io/servers/cybeleri-database-admin/database-admin-mcp