Claude Code: MCP (Model Context Protocol)

# Without MCP: Manual database query
> Check how many records are in the users table
Claude Code: I can't access the database directly. Run:
  psql -c "SELECT COUNT(*) FROM users"

# With MCP (PostgreSQL Server): Direct query
> Check how many records are in the users table
Claude Code: [Query via PostgreSQL MCP]
  users table has 12,450 records.
  Active users: 8,920 (71.6%),
  Registered in last 7 days: 342.

// ~/.claude/mcp_settings.json
{
  "mcpServers": {
    "filesystem": {
      "command": "npx",
      "args": ["-y", "@anthropic/mcp-filesystem", "/home/user/projects"]
    },
    "postgres": {
      "command": "npx",
      "args": ["-y", "@anthropic/mcp-postgres"],
      "env": {
        "DATABASE_URL": "postgresql://user:pass@localhost:5432/mydb"
      }
    }
  }
}

// .claude/mcp_settings.json
{
  "mcpServers": {
    "github": {
      "command": "npx",
      "args": ["-y", "@anthropic/mcp-github"],
      "env": {
        "GITHUB_TOKEN": "ghp_xxxxx"
      }
    }
  }
}

> Query user registrations in the last 7 days, grouped by day

Claude Code: [Using PostgreSQL MCP]
  → Executing SQL query...
  Results: 7-day breakdown with daily counts

import { Server } from "@anthropic/mcp";

const server = new Server({
  name: "weather",
  version: "1.0.0",
});

server.tool("get_weather", "Get current weather for a city", {
  city: { type: "string", description: "City name" },
}, async ({ city }) => {
  const response = await fetch(
    `https://api.weather.com/current?city=${city}`
  );
  const data = await response.json();
  return {
    content: [{
      type: "text",
      text: `${city}: ${data.temperature}°C, ${data.condition}`
    }]
  };
});

server.start();