MCP

// ~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:pass@localhost:5432/avva"
      ]
    },
    "filesystem": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-filesystem",
        "/Users/me/projects"
      ]
    }
  }
}

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

const server = new McpServer({
  name: "avva-orders",
  version: "1.0.0",
});

// Tool: bir siparişi sorgula
server.tool(
  "get_order",
  "Sipariş numarasından sipariş detayı döner",
  { order_id: z.string() },
  async ({ order_id }) => {
    const row = await db.query("SELECT * FROM orders WHERE id = $1", [order_id]);
    return {
      content: [{ type: "text", text: JSON.stringify(row) }],
    };
  },
);

await server.connect(new StdioServerTransport());