Skip to main content
Glama
@orphnet/d1-eloquent-mcp

@orphnet/d1-eloquent-mcp

by Orphnet

@orphnet/d1-eloquent-mcp

MCP 服务器,为 Claude (以及任何 Model Context Protocol–兼容的客户端) 提供对您的 d1-eloquent 项目的实时、上下文感知的访问——模型、迁移、模式、填充器、工厂和 CLI。

bunx @orphnet/d1-eloquent-mcp

它能给 Claude 带来什么

24 个工具、6 个资源、2 个提示。

内省 (只读)

  • list_models · read_model · list_migrations · read_migration · migration_status

  • inspect_schema - 查询 sqlite_master 以查看您的 D1 中实际存在的内容

  • query_d1 - 针对本地 D1 的只读 SQL (仅限 SELECT/WITH/EXPLAIN/PRAGMA)

  • list_seeders · list_factories · read_file · refresh_project

  • validate_model · validate_all - 将声明的模型形状与实际模式进行比较,报告差异

生成 (委托给 d1-eloquent CLI)

  • make_model · make_migration · make_seeder · make_factory

  • make_resource - 一次完成模型 + 迁移 + 填充器 + 工厂

  • make_pivot

执行 (委托给 d1-eloquent CLI,默认使用本地 D1)

  • run_migrate · run_rollback · run_fresh · run_seed

  • run_generate - 模式差异:编写迁移,弥补模型与实时模式之间的差距

资源 - Claude 可以将这些作为背景上下文引入

  • d1-eloquent://project/summary - 您项目中发现的状态

  • d1-eloquent://docs/api/base-model

  • d1-eloquent://docs/api/query-builder

  • d1-eloquent://docs/api/relationships

  • d1-eloquent://docs/api/transactions

  • d1-eloquent://docs/guide/quick-start

提示 - 预构建的多步骤工作流程

  • create-model - 在单次聊天中完成脚手架生成 + 迁移 + 验证

  • audit-schema - 将每个模型与实际 D1 模式进行比较,报告差异

Related MCP server: MCP Database Bridge

安装

Claude Code

claude mcp add d1-eloquent -- bunx @orphnet/d1-eloquent-mcp

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) 或 %APPDATA%\Claude\claude_desktop_config.json (Windows):

{
  "mcpServers": {
    "d1-eloquent": {
      "command": "bunx",
      "args": ["@orphnet/d1-eloquent-mcp"]
    }
  }
}

按项目 (Claude Code)

.claude/mcp.json:

{
  "mcpServers": {
    "d1-eloquent": {
      "command": "bunx",
      "args": ["@orphnet/d1-eloquent-mcp"]
    }
  }
}

要指向非当前目录的项目:

{
  "mcpServers": {
    "d1-eloquent": {
      "command": "bunx",
      "args": ["@orphnet/d1-eloquent-mcp", "--project", "/path/to/your/d1-eloquent-project"]
    }
  }
}

要求

  • Node.js ≥ 22

  • 已安装 wrangler 并完成 D1 访问认证 (bun add -D wrangler)

  • 一个已有的 @orphnet/d1-eloquent 项目 - 服务器通过扫描文件树来发现模型/迁移/填充器

安全性

  • query_d1 拒绝除 SELECT / WITH / EXPLAIN / PRAGMA 之外的任何操作,并拒绝多语句负载。

  • read_file 拒绝包含 .. 或以 / 开头的路径。

  • 生成工具会调用您现有的 d1-eloquent CLI - 它们不包含自己的写入器。

  • 执行工具 (run_migrate / run_rollback / run_fresh / run_seed) 默认仅操作本地 D1。对于远程环境,请直接通过 CLI 运行。

许可证

MIT

Available Tools

24 tools
inspect_schemaA

Query the local D1 sqlite_master to list every table + the column definitions actually applied. Read-only.

Inputs: db, table.

list_factoriesA

List discovered factory files. Read-only.

Inputs: no named parameters.

list_migrationsB

List all discovered migration files with timestamps. Read-only.

Inputs: no named parameters.

list_modelsA

List all discovered BaseModel subclasses in the project, with table names and feature flags (soft deletes, revisions, relationships, casts). Read-only.

Inputs: no named parameters.

list_seedersA

List discovered seeder files. Read-only.

Inputs: no named parameters.

make_factoryB

Scaffold a new factory. Delegates to d1-eloquent make:factory.

Inputs: name (required).

make_migrationB

Scaffold a new migration. Delegates to d1-eloquent make:migration.

Inputs: name (required).

make_modelB

Scaffold a new model file. Delegates to d1-eloquent make:model.

Inputs: name (required), softDeletes.

make_pivotB

Scaffold a pivot table migration. Delegates to d1-eloquent make:pivot.

Inputs: table (required).

make_resourceB

Scaffold model + migration + seeder + factory in one go. Delegates to d1-eloquent make:resource.

Inputs: name (required), softDeletes.

make_seederC

Scaffold a new seeder. Delegates to d1-eloquent make:seeder.

Inputs: name (required).

migration_statusA

Run d1-eloquent status against the local D1 - shows which migrations have run vs pending. Read-only. The CLI resolves the D1 binding from wrangler config automatically.

Inputs: no named parameters.

query_d1A

Run a read-only SQL query (SELECT / WITH / EXPLAIN / PRAGMA only) against the local D1. Multi-statement payloads and writes are rejected.

Inputs: sql (required), db.

read_fileA

Read any project file by path (relative to project root). Read-only.

Inputs: path (required).

read_migrationB

Return the source of a migration file. Read-only.

Inputs: name (required).

read_modelA

Return the full source code of a model file plus parsed metadata (relations, casts, static config). Read-only.

Inputs: name (required).

refresh_projectB

Re-run project discovery, update cached state.

Inputs: no named parameters.

run_freshA

Drop all tables and re-run every migration. Delegates to d1-eloquent fresh --force.

Inputs: no named parameters.

run_generateA

Diff models against the project's migrations (schema diff) and report what a reconciling migration would change. Dry-run by default: prints per-model added/dropped/type-changed columns and writes NOTHING. Pass write=true to emit migration file(s) into the project's migrations directory (review them, then run_migrate). Delegates to d1-eloquent generate.

Inputs: name, model, write.

run_migrateB

Apply pending migrations. Delegates to d1-eloquent migrate against local D1.

Inputs: no named parameters.

run_rollbackA

Roll back the last migration batch. Delegates to d1-eloquent rollback.

Inputs: no named parameters.

run_seedC

Run seeders. Delegates to d1-eloquent seed.

Inputs: seeder.

validate_allA

Run validate_model across every discovered model. Returns per-model issues and a summary count of ok / warn / fail.

Inputs: no named parameters.

validate_modelA

Compare a single model's declared shape (table, casts, softDeletes, timestamps, revisions) against the actual local D1 schema and return any drift as a list of issues.

Inputs: name (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.6/5.0

    Scored across 24 tools

    Disambiguation5/5

    Each tool targets a distinct resource and action (list vs read vs make vs run vs validate). Even closely related tools like validate_model and validate_all are clearly differentiated by scope (single vs all). There is no ambiguity in purpose.

    Naming Consistency4/5

    The overwhelming majority use verb_noun snake_case (list_*, make_*, run_*, read_*). The only deviation is migration_status, which uses noun_noun instead of a verb prefix, but this is a minor inconsistency that does not hinder readability.

    Tool Count3/5

    At 24 tools, the set falls in the 16-25 range that feels heavy. While each tool serves a distinct purpose in the D1/Eloquent workflow, the high number may be overwhelming and includes some conveniences (like make_resource) that could be assembled from others.

    Completeness5/5

    The tool set covers the full lifecycle: listing/reading artifacts, scaffolding (model, migration, seeder, factory, pivot), running migrations/seeds/rollbacks, schema inspection, validation, and even raw SQL queries. No significant gaps are apparent for the stated scope.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      C
      maintenance
      Enables AI-assisted analysis and optimization of Cloudflare D1 databases through comprehensive schema introspection, relationship mapping, validation, and optimization recommendations. Demonstrates semantic intent patterns with hexagonal architecture for maintainable database development workflows.
      4
      3
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      A Node.js MCP server that gives Claude Code direct access to file operations, database queries, PHP execution, SFTP deployment, and over 60 specialized tools for development and debugging.
      1
      MIT