mcp-server-bigquery vs filesystem

Side-by-side comparison to help you pick between these two MCP servers.

	mcp-server-bigquery by LucasHild	filesystem by modelcontextprotocol
Stars	★ 126	★ 85,748
30d uses	—	—
Score	47	77
Official	—	✓
Categories	DatabaseDeveloper ToolsAI / LLM Tools	File SystemDeveloper ToolsProductivity
Language	Python	TypeScript
Last commit	2 mo ago	this month

mcp-server-bigquery · Summary

An MCP server enabling LLMs to inspect BigQuery schemas and execute SQL queries.

filesystem · Summary

A feature-rich MCP server for filesystem operations with dynamic directory access control.

mcp-server-bigquery · Use cases

AI-powered data analysis by letting LLMs directly query BigQuery datasets
Automated report generation based on real-time data from BigQuery
Data discovery and schema exploration for data science workflows

filesystem · Use cases

Enable AI models to read and write project files during development
Allow Claude or other MCP clients to browse and analyze codebases
Provide secure sandboxed access to specific directories for content generation

mcp-server-bigquery · Install

Installation

Via Smithery

npx -y @smithery/cli install mcp-server-bigquery --client claude

Claude Desktop

Add to your Claude Desktop config:

{
  "mcpServers": {
    "bigquery": {
      "command": "uvx",
      "args": ["mcp-server-bigquery"],
      "env": {
        "BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
        "BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
      }
    }
  }
}

Command Line

claude mcp add bigquery --scope user --transport stdio -- uvx mcp-server-bigquery --project {PROJECT_ID} --location {LOCATION}

filesystem · Install

Installation

Using NPX

{
  "mcpServers": {
    "filesystem": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-filesystem",
        "/path/to/allowed/directory"
      ]
    }
  }
}

Using Docker

{
  "mcpServers": {
    "filesystem": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "--mount", "type=bind,src=/path/to/allowed/dir,dst=/projects/allowed/dir",
        "mcp/filesystem",
        "/projects"
      ]
    }
  }
}

VS Code Extension

Click the installation buttons in the README to install directly in VS Code.

Comparison generated from public README + GitHub signals. Last updated automatically.