database-operations-mcp

sandraschi/database-operations-mcp

3.3

If you are the rightful owner of database-operations-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

The Universal Database Operations MCP Server is a comprehensive solution for managing and interacting with multiple database systems using the Model Context Protocol.

Tools
5
Resources
0
Prompts
0

Python FastMCP

Database Operations MCP

FastMCP 2.13 MCP server for database-centric operations on Windows, with powerful bookmark tooling as an add-on (because large bookmark collections are a kind of database).

What this repo is

  • Primary: Database tools (inspection, backup/restore, analysis, Windows app databases)
  • Secondary: Bookmark tools (Firefox + Chromium family) including cross-browser sync

Tools Overview

This server provides 23 portmanteau tools consolidating 124+ individual operations into unified interfaces. Individual tools have been deprecated in favor of portmanteau tools for better maintainability and consistency.

Database Tools (Primary)

  • db_connection - Database connection management portmanteau (consolidates connection_tools, init_tools)
    • Operations: list_supported, register, init, list, test, test_all, close, get_info, restore, set_active, get_active, get_preferences, set_preferences
  • db_operations - Query execution, transactions, batch operations, data export portmanteau (consolidates query_tools, data_tools)
    • Operations: execute_query, execute_transaction, execute_write, batch_insert, quick_data_sample, export_query_results
  • db_schema - Schema inspection, table/column/index analysis portmanteau (consolidates schema_tools)
    • Operations: list_databases, list_tables, describe_table, get_schema_diff
  • db_management - Database health checks, optimization, backup/restore portmanteau (consolidates management_tools)
  • db_fts - Full-text search with ranking and highlighting portmanteau (consolidates fts_tools)
  • db_analysis - Comprehensive database analysis and diagnostics portmanteau
  • windows_system - Windows Registry, service status, system info portmanteau (consolidates registry_tools, windows_tools)

Bookmark Tools (Secondary)

  • browser_bookmarks - Universal browser bookmark portmanteau (Firefox/Chrome/Edge/Brave)
    • Operations: list_bookmarks, add_bookmark, edit_bookmark, delete_bookmark, search_bookmarks, get_bookmark, and 20+ more
    • Supports all browsers through single interface
  • firefox_bookmarks - Firefox-specific bookmark operations (SQLite-based)
    • Operations: list_bookmarks, add_bookmark, search, find_duplicates, find_old_bookmarks, find_forgotten_bookmarks, refresh_bookmarks, get_bookmark_stats, find_broken_links
    • Tag management: list_tags, find_similar_tags, batch_update_tags, merge_tags, clean_up_tags
    • Note: Write operations require Firefox to be closed (SQLite lock)
  • firefox_profiles - Firefox profile management portmanteau
  • firefox_backup - Firefox backup/restore operations
  • firefox_tagging - Automated tagging (by folder, by year)
  • sync_bookmarks - Cross-browser bookmark synchronization (Firefox ↔ Chromium family)
  • chrome_profiles - Chrome profile management portmanteau

Media & Other Tools

  • media_library - Calibre & Plex library management portmanteau (consolidates calibre_tools, plex_tools, media_tools)
  • help_system - Interactive help and documentation portmanteau (consolidates help_tools)
  • system_init - System initialization and setup portmanteau

Deprecated Tools (Use Portmanteau Equivalents)

Individual tools are deprecated but kept for backwards compatibility. Migration paths:

  • connection_tools.* → db_connection(operation='...')
  • init_tools.* → db_connection(operation='...')
  • query_tools.* → db_operations(operation='...')
  • data_tools.* → db_operations(operation='...')
  • schema_tools.* → db_schema(operation='...')
  • management_tools.* → db_management(operation='...')
  • fts_tools.* → db_fts(operation='...')
  • calibre_tools.* → media_library(operation='...')
  • plex_tools.* → media_library(operation='...')
  • registry_tools.* → windows_system(operation='...')
  • windows_tools.* → windows_system(operation='...')

See individual tool files in src/database_operations_mcp/tools/ for complete API documentation.

Core Database Features (Primary)

  • SQLite utilities: open/read, schema introspection, queries, export
  • Backup and restore helpers for common Windows application databases
  • Windows paths helpers (Chrome/Edge/Brave/Firefox history, Outlook, etc.)
  • Safety helpers (file locks, status checks) with clear error messages
  • MCP tools organized under src/database_operations_mcp/tools/

Representative Tools

  • Windows DB helpers: windows_tools.py
  • Firefox DB safety/status: tools/firefox/status.py
  • Backup/maintenance helpers across known app DBs

Bookmark Tools (Secondary)

Cross-browser bookmark utilities packaged with this server.

Firefox Bookmarks (SQLite-based)

Important: Write operations require Firefox to be closed (SQLite database lock). Read operations work while Firefox is running using force_access=True.

Core Operations
# List bookmarks
await firefox_bookmarks(operation="list_bookmarks", profile_name="default")

# Add bookmark (Firefox must be closed!)
await firefox_bookmarks(operation="add_bookmark", url="https://example.com", title="Example")

# Search bookmarks
await firefox_bookmarks(operation="search", search_query="python")
Bookmark Age Analysis
# Find OLD bookmarks (by CREATION date) - e.g. bookmarks from 2005
await firefox_bookmarks(operation="find_old_bookmarks", age_days=7000)
# Returns: bookmarks with age_years, age_days, created timestamp

# Find FORGOTTEN bookmarks (not VISITED in N days) - archive candidates
await firefox_bookmarks(operation="find_forgotten_bookmarks", age_days=365)
# Returns: suggestion to archive/delete these unused bookmarks

# Refresh bookmarks - check for 404s, attempt URL fixes
await firefox_bookmarks(operation="refresh_bookmarks", batch_size=100)
# Returns: working/broken counts, fixable URLs with simplified alternatives
Tag Management
await firefox_bookmarks(operation="list_tags")
await firefox_bookmarks(operation="find_similar_tags")  # Find typos like "pythn" vs "python"
await firefox_bookmarks(operation="merge_tags", tags=["python", "pythn"])  # Requires Firefox closed
Statistics & Maintenance
await firefox_bookmarks(operation="get_bookmark_stats")
await firefox_bookmarks(operation="find_duplicates")
await firefox_bookmarks(operation="find_broken_links")

Chrome / Edge / Brave (JSON)

  • list_chrome_bookmarks(bookmarks_path=None)
  • list_edge_bookmarks(bookmarks_path=None)

Chromium Portmanteau (Chrome/Edge/Brave)

  • chromium_bookmarks(operation, browser, ...) unified tool
    • list: operation="list", browser="chrome|edge|brave", limit?, bookmarks_path?
    • add: operation="add", title, url, folder?, allow_duplicates?, bookmarks_path?
    • edit: operation="edit", id? or url?, new_title?, new_folder?, create_folders?, allow_duplicates?, dry_run?, bookmarks_path?
    • delete: operation="delete", id? or url?, dry_run?, bookmarks_path?
# List first 50 Edge bookmarks via portmanteau
await chromium_bookmarks(operation="list", browser="edge", limit=50)

# Add to Brave in folder "Reading/Tech"
await chromium_bookmarks(operation="add", browser="brave", title="Docs", url="https://example.com/docs", folder="Reading/Tech")

# Rename and move a Chrome bookmark by URL (dry run)
await chromium_bookmarks(operation="edit", browser="chrome", url="https://example.com/docs", new_title="Docs Home", new_folder="Reading/Docs", dry_run=True)

# Delete by id in Edge
await chromium_bookmarks(operation="delete", browser="edge", id="12345")
  • list_brave_bookmarks(bookmarks_path=None)
  • add_chrome_bookmark(title, url, folder=None, bookmarks_path=None)
  • add_edge_bookmark(title, url, folder=None, bookmarks_path=None)
  • add_brave_bookmark(title, url, folder=None, bookmarks_path=None)

Cross-Browser Sync

  • sync_bookmarks(source_browser, target_browser, dry_run=True, limit=1000)
    • Set dry_run=False to write to target.
    • If writing to Firefox while it's open, the result will include: "error. firefox must be closed".

Examples

# List Chrome bookmarks
await list_chrome_bookmarks()

# Add to Edge
await add_edge_bookmark(title="Example", url="https://example.com")

# Sync from Firefox to Chrome (write)
await sync_bookmarks("firefox", "chrome", dry_run=False, limit=100)

Project Layout

database-operations-mcp/
├── src/
│   └── database_operations_mcp/
│       ├── main.py                      # MCP server entry
│       ├── config/
│       │   └── mcp_config.py            # shared MCP instance
│       └── tools/
│           ├── firefox/                 # Firefox bookmark + DB helpers
│           ├── chrome/                  # Chrome bookmark tools
│           ├── edge/                    # Edge bookmark tools
│           ├── brave/                   # Brave bookmark tools
│           ├── chromium_common.py       # Shared Chromium JSON helpers
│           └── sync_tools.py            # Cross-browser sync tool
├── tests/
└── README.md

Install via MCPB Package (Claude Desktop)

  • Download or build the .mcpb package.
  • In Claude Desktop, open Extensions and drag-and-drop the .mcpb file.
  • Restart Claude Desktop if prompted.

Configure in Cursor / Claude (recommended)

Transports: stdio and HTTP

  • Default: dual (both stdio and HTTP) unless overridden
  • Override via env: set MCP_TRANSPORT=stdio|http|dual
  • HTTP host/port via MCP_HOST (default 0.0.0.0) and MCP_PORT (default 8000)
  • CLI flags: --stdio, --http, --dual
# HTTP only on port 3210
$env:MCP_TRANSPORT = "http"
$env:MCP_PORT = "3210"
uv run python -m database_operations_mcp.main --http

# Dual mode (stdio + HTTP) with custom host/port
$env:MCP_TRANSPORT = "dual"
$env:MCP_HOST = "127.0.0.1"
$env:MCP_PORT = "9000"
uv run python -m database_operations_mcp.main --dual

Add the server to your MCP config (%USERPROFILE%\AppData\Roaming\Cursor\.cursor\mcp.json or equivalent):

{
  "mcpServers": {
    "database-operations-mcp": {
      "command": "uv",
      "args": ["run", "python", "-m", "database_operations_mcp.main"],
      "env": { "LOG_LEVEL": "INFO" }
    }
  }
}

Development

For Python development setup, testing, and contribution guidelines, see .

Requirements

  • Python 3.10+
  • FastMCP 2.13
  • Supported browsers installed (for bookmark tools)

License

MIT License - see LICENSE file.