@orphnet/d1-eloquent-mcp
@orphnet/d1-eloquent-mcp
MCP-Server, der Claude (und jedem mit dem Model Context Protocol kompatiblen Client) live, kontextbezogenen Zugriff auf Ihr d1-eloquent-Projekt bietet - Modelle, Migrationen, Schema, Seeder, Fabriken und die CLI.
bunx @orphnet/d1-eloquent-mcpWas es Claude bietet
24 Tools, 6 Ressourcen, 2 Prompts.
Introspektion (nur lesend)
list_models·read_model·list_migrations·read_migration·migration_statusinspect_schema- fragtsqlite_masterab, um zu sehen, was tatsächlich in Ihrer D1 istquery_d1- schreibgeschütztes SQL gegen die lokale D1 (nur SELECT/WITH/EXPLAIN/PRAGMA)list_seeders·list_factories·read_file·refresh_projectvalidate_model·validate_all- deklarierte Modellstruktur mit dem tatsächlichen Schema vergleichen, Abweichungen melden
Generierung (delegiert an die d1-eloquent CLI)
make_model·make_migration·make_seeder·make_factorymake_resource- Modell + Migration + Seeder + Factory in einem Zugmake_pivot
Ausführung (delegiert an die d1-eloquent CLI, standardmäßig lokale D1)
run_migrate·run_rollback·run_fresh·run_seedrun_generate- Schema-Diff: schreibt die Migration, die die Lücke zwischen Ihren Modellen und dem Live-Schema schließt
Ressourcen - Claude kann diese als Hintergrundkontext einbinden
d1-eloquent://project/summary- der ermittelte Zustand Ihres Projektsd1-eloquent://docs/api/base-modeld1-eloquent://docs/api/query-builderd1-eloquent://docs/api/relationshipsd1-eloquent://docs/api/transactionsd1-eloquent://docs/guide/quick-start
Prompts - vorgefertigte mehrstufige Workflows
create-model- Scaffolding + Migration + Verifizierung in einem Chataudit-schema- jedes Modell mit dem tatsächlichen D1-Schema vergleichen, Abweichungen melden
Related MCP server: MCP Database Bridge
Installation
Claude Code
claude mcp add d1-eloquent -- bunx @orphnet/d1-eloquent-mcpClaude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json (macOS) oder %APPDATA%\Claude\claude_desktop_config.json (Windows):
{
"mcpServers": {
"d1-eloquent": {
"command": "bunx",
"args": ["@orphnet/d1-eloquent-mcp"]
}
}
}Pro Projekt (Claude Code)
.claude/mcp.json:
{
"mcpServers": {
"d1-eloquent": {
"command": "bunx",
"args": ["@orphnet/d1-eloquent-mcp"]
}
}
}Um auf ein Projekt zu verweisen, das nicht das aktuelle Verzeichnis ist:
{
"mcpServers": {
"d1-eloquent": {
"command": "bunx",
"args": ["@orphnet/d1-eloquent-mcp", "--project", "/path/to/your/d1-eloquent-project"]
}
}
}Voraussetzungen
Node.js ≥ 22
wranglerinstalliert und für den D1-Zugriff authentifiziert (bun add -D wrangler)Ein bestehendes
@orphnet/d1-eloquent-Projekt - der Server findet Modelle/Migrationen/Seeder, indem er Ihren Dateibaum durchsucht
Sicherheit
query_d1akzeptiert nurSELECT/WITH/EXPLAIN/PRAGMAund weist Nutzlasten mit mehreren Anweisungen zurück.read_fileweist Pfade zurück, die..enthalten oder mit/beginnen.Generierungswerkzeuge rufen Ihre vorhandene d1-eloquent CLI auf - sie bringen keine eigenen Writer mit.
Ausführungswerkzeuge (
run_migrate/run_rollback/run_fresh/run_seed) arbeiten standardmäßig nur mit der lokalen D1. Für Remote führen Sie die CLI direkt aus.
Lizenz
MIT
Available Tools
24 toolsinspect_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
Scored across 24 tools
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.
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.
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.
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
Related MCP Connectors
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Build, deploy and manage MaShop e-commerce projects from Claude, Cursor or any MCP client.
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Work on your own computers from Claude or ChatGPT: run commands, edit and search files.
Related MCP Servers
AlicenseAqualityCmaintenanceEnables 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.43MIT- FlicenseNot gradedqualityCmaintenanceA secure, read-only MCP server that empowers Claude Desktop and AI agents to safely query and inspect local SQLite databases.-
- AlicenseNot gradedqualityBmaintenanceA 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.1MIT
- AlicenseAqualityCmaintenanceMCP server for Cloudflare D1 database introspection, providing schema analysis, relationship extraction, validation, and optimization suggestions via Semantic Intent patterns.52MIT