MCP Integrations

{
  "mcpServers": {
    "postgres-reader": {
      "command": "node",
      "args": ["./mcp-servers/postgres-reader/index.js"],
      "env": {
        "DATABASE_URL": "${env:DATABASE_URL}"
      }
    },
    "github": {
      "command": "npx",
      "args": ["-y", "@anthropic/mcp-server-github"],
      "env": {
        "GITHUB_TOKEN": "${env:GITHUB_TOKEN}"
      }
    },
    "remote-stripe": {
      "type": "http",
      "url": "https://mcp.stripe.com/v1",
      "headers": {
        "Authorization": "Bearer ${env:STRIPE_KEY}"
      }
    }
  },
  "permissions": {
    "allow": ["mcp__postgres-reader__query", "mcp__github__list_prs"]
  }
}

{
  "hooks": {
    "PreToolUse": [
      {
        "matcher": "mcp__postgres-reader__*",
        "hooks": [
          {
            "type": "command",
            "command": "node ./scripts/log-db-query.js"
          }
        ]
      }
    ]
  }
}

## MCP Servers

### postgres-reader (local stdio)
command: node ./mcp-servers/postgres-reader/index.js
env:
  DATABASE_URL: $DATABASE_URL

### stripe (remote OAuth)
url: https://mcp.stripe.com/v1
auth: oauth2
scopes: [read:charges, read:customers]

## Extensions

Installed extensions (via gemini extensions install):
- @google/mcp-figma         (Figma design token access)
- @google/mcp-postman       (API testing via Postman collections)
- @google/mcp-workspace     (Google Docs, Sheets, Gmail)

# Install a Google partner extension
gemini extensions install @google/mcp-figma

# List installed extensions
gemini extensions list

# Remove an extension
gemini extensions remove @google/mcp-figma

# Install a custom MCP server as an extension
gemini extensions install --path ./mcp-servers/my-server/

# Extensions show up automatically as tools in your Gemini session
# No restart needed

// ~/.vscode/settings.json (VS Code only — NOT available in gh copilot CLI)
{
  "github.copilot.chat.mcp.servers": {
    "postgres-reader": {
      "command": "node",
      "args": ["./mcp-servers/postgres-reader/index.js"],
      "env": {
        "DATABASE_URL": "${env:DATABASE_URL}"
      }
    }
  }
}

// In the terminal (gh copilot):
// gh copilot suggest "query the users table for inactive accounts"
// → MCP is NOT available — Copilot CLI has no database context
// → Suggested command: psql $DATABASE_URL -c "SELECT ..."
// → You run it manually

// WHAT: A custom MCP server that reads Postgres tables
// WHY:  Write once — works with Claude Code, Gemini CLI, Cursor, VS Code Copilot
// GOTCHA: Run 'npm install @modelcontextprotocol/sdk pg' first

import { McpServer } from '@modelcontextprotocol/sdk/server/mcp.js';
import { StdioServerTransport } from '@modelcontextprotocol/sdk/server/stdio.js';
import { z } from 'zod';
import pg from 'pg';

// WHAT: Create the MCP server — tools are registered below
const server = new McpServer({ name: 'postgres-reader', version: '1.0.0' });
const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL });

// WHAT: Register a tool — AI clients call this tool by its name
// WHY:  Any MCP-compatible client (Claude Code, Gemini, Cursor) discovers
//       this tool automatically when connected to this server
server.tool(
  'query_table',
  'Read rows from a Postgres table (read-only)',
  {
    table_name: z.string().describe('Table name to query'),
    limit: z.number().max(1000).default(50).describe('Max rows to return'),
    where: z.string().optional().describe('Optional WHERE clause (no semicolons)'),
  },
  async ({ table_name, limit, where }) => {
    // GOTCHA: Never allow raw SQL injection — only allow table name + WHERE
    const allowedTables = process.env.ALLOWED_TABLES?.split(',') ?? [];
    if (!allowedTables.includes(table_name)) {
      return { content: [{ type: 'text', text: `Table '${table_name}' not in allowlist` }] };
    }

    const whereClause = where ? `WHERE ${where.replace(/;/g, '')}` : '';
    const result = await pool.query(
      `SELECT * FROM ${table_name} ${whereClause} LIMIT $1`,
      [limit],
    );

    return {
      content: [{
        type: 'text',
        text: JSON.stringify(result.rows, null, 2),
      }],
    };
  },
);

// WHAT: Start listening on stdio transport
// This is the same transport that both Claude Code and Gemini CLI use
const transport = new StdioServerTransport();
await server.connect(transport);