Database MCP

A structured collection of data organized for efficient storage, retrieval, and management.

Installation

npx @dotdo/mcp install database

Tools

database_create

Initialize a new database with specified schema and configuration.

Tool Schema:

{
  "name": "database_create",
  "description": "Initialize a new database with specified schema and configuration.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_update

Modify database configuration, schema, or settings.

Tool Schema:

{
  "name": "database_update",
  "description": "Modify database configuration, schema, or settings.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_delete

Permanently remove the database and all contained data.

Tool Schema:

{
  "name": "database_delete",
  "description": "Permanently remove the database and all contained data.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_backup

Create a point-in-time snapshot for disaster recovery.

Tool Schema:

{
  "name": "database_backup",
  "description": "Create a point-in-time snapshot for disaster recovery.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_restore

Recover database data from a previous backup snapshot.

Tool Schema:

{
  "name": "database_restore",
  "description": "Recover database data from a previous backup snapshot.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_migrate

Transfer database to a different version, engine, or location.

Tool Schema:

{
  "name": "database_migrate",
  "description": "Transfer database to a different version, engine, or location.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_query

Execute read operations to retrieve data.

Tool Schema:

{
  "name": "database_query",
  "description": "Execute read operations to retrieve data.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_insert

Add new records or documents.

Tool Schema:

{
  "name": "database_insert",
  "description": "Add new records or documents.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_updateRecords

Modify existing records or documents.

Tool Schema:

{
  "name": "database_updateRecords",
  "description": "Modify existing records or documents.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_deleteRecords

Remove records matching specified criteria.

Tool Schema:

{
  "name": "database_deleteRecords",
  "description": "Remove records matching specified criteria.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_index

Create optimized data structures to accelerate queries.

Tool Schema:

{
  "name": "database_index",
  "description": "Create optimized data structures to accelerate queries.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

database_optimize

Improve performance through tuning or resource allocation.

Tool Schema:

{
  "name": "database_optimize",
  "description": "Improve performance through tuning or resource allocation.",
  "inputSchema": {
    "type": "object",
    "properties": {
      // Tool parameters
    }
  }
}

Resources

database/created

Triggered when a new database is initialized.

Resource URI: database://created

database/updated

Triggered when database configuration or schema is modified.

Resource URI: database://updated

database/deleted

Triggered when a database is permanently removed.

Resource URI: database://deleted

database/backedUp

Triggered when a backup snapshot is created.

Resource URI: database://backedUp

database/restored

Triggered when database is recovered from backup.

Resource URI: database://restored

database/migrated

Triggered when database migration completes.

Resource URI: database://migrated

database/queried

Triggered when read operations retrieve data.

Resource URI: database://queried

database/inserted

Triggered when new records are added.

Resource URI: database://inserted

database/recordsUpdated

Triggered when existing records are modified.

Resource URI: database://recordsUpdated

database/recordsDeleted

Triggered when records are removed.

Resource URI: database://recordsDeleted

database/indexed

Triggered when indexes are created or rebuilt.

Resource URI: database://indexed

database/optimized

Triggered when performance improvements are applied.

Resource URI: database://optimized

database/connectionLimitReached

Triggered when active connections reach maximum threshold.

Resource URI: database://connectionLimitReached

database/error

Triggered when operational failures occur.

Resource URI: database://error

Usage with Claude Desktop

Add to claude_desktop_config.json:

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

Database MCP

On this page