StackMCP

Data Engineer Stack for VS Code

Intermediate6 servers34.5K tokens

Configuration

{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ],
      "env": {
        "POSTGRES_CONNECTION_STRING": "YOUR_POSTGRES_CONNECTION_STRING"
      }
    },
    "mongodb-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mongodb-mcp"
      ],
      "env": {
        "MONGODB_URI": "YOUR_MONGODB_URI"
      }
    },
    "redis-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "redis-mcp"
      ],
      "env": {
        "REDIS_URL": "YOUR_REDIS_URL"
      }
    },
    "filesystem-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-filesystem",
        "/path/to/allowed/directory"
      ]
    },
    "github-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-github"
      ],
      "env": {
        "GITHUB_PERSONAL_ACCESS_TOKEN": "YOUR_GITHUB_PERSONAL_ACCESS_TOKEN"
      }
    },
    "docker-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "docker-mcp"
      ]
    }
  }
}

Where to save

Paste the config above into:

.vscode/settings.json → mcp section

Environment Variables

Replace the YOUR_ placeholders with your actual values.

POSTGRES_CONNECTION_STRINGrequired

PostgreSQL connection string (e.g. postgresql://user:pass@localhost:5432/mydb)

Used by: PostgreSQL MCP

MONGODB_URIrequired

MongoDB connection URI

Used by: MongoDB MCP

REDIS_URLrequired

Redis connection URL

Used by: Redis MCP

GITHUB_PERSONAL_ACCESS_TOKENrequired

GitHub personal access token

Used by: GitHub MCP

What’s in this stack

PostgreSQL MCP8 tools

Query and interact with PostgreSQL databases, inspect schemas, and run SQL directly from your AI editor.

Queries and manages your primary relational data warehouse where structured data lives and transforms happen.

MongoDB MCP6 tools

Query MongoDB databases, inspect collections, and analyze documents directly from your AI editor.

Handles unstructured and semi-structured data ingestion from APIs, logs, and event streams.

Redis MCP8 tools

Interact with Redis databases. Get, set, and manage keys, run commands, and monitor your Redis instances from your AI editor.

Provides high-speed caching and message queuing for real-time data pipeline orchestration.

Filesystem MCP11 tools

Read, write, search, and manage files on your local filesystem with secure directory-scoped access for your AI editor.

Reads and writes CSV, JSON, and Parquet files for batch processing and data staging between pipeline steps.

GitHub MCP20 tools

Access the GitHub API to manage repositories, issues, pull requests, branches, and workflows directly from your AI editor.

Version-controls your pipeline code, dbt models, and transformation scripts with proper review workflows.

Docker MCP14 tools

Manage Docker containers, images, volumes, and networks. Run, stop, inspect, and monitor containers from your AI editor.

Containerizes pipeline jobs for consistent execution across development, staging, and production environments.

Other editors

Claude CodeCursorWindsurfClaude DesktopContinue