PostGIS MCP Server

Instructions

Implementation Reference

• server.ts:1796-1840 (handler)

  Handler implementation for 'raster-info' tool. Parses input schema, sanitizes parameters, queries PostGIS for raster metadata (num_bands, width, height, pixel sizes, SRID, envelope, tile_count), and returns JSON response.

  case "raster-info": {
    const { table_name, raster_column } = RasterInfoSchema.parse(args);
  
    const sanitizedTableName = table_name.replace(/[^a-zA-Z0-9_]/g, "");
    const sanitizedRasterColumn = raster_column || "rast";
  
    const result = await client.query(`
      SELECT 
        ST_NumBands(${sanitizedRasterColumn}) as num_bands,
        ST_Width(${sanitizedRasterColumn}) as width,
        ST_Height(${sanitizedRasterColumn}) as height,
        ST_PixelWidth(${sanitizedRasterColumn}) as pixel_width,
        ST_PixelHeight(${sanitizedRasterColumn}) as pixel_height,
        ST_SRID(${sanitizedRasterColumn}) as srid,
        ST_AsText(ST_Envelope(${sanitizedRasterColumn})) as envelope_wkt,
        COUNT(*) as tile_count
      FROM ${sanitizedTableName}
      GROUP BY 
        ST_NumBands(${sanitizedRasterColumn}),
        ST_Width(${sanitizedRasterColumn}),
        ST_Height(${sanitizedRasterColumn}),
        ST_PixelWidth(${sanitizedRasterColumn}),
        ST_PixelHeight(${sanitizedRasterColumn}),
        ST_SRID(${sanitizedRasterColumn}),
        ST_AsText(ST_Envelope(${sanitizedRasterColumn}))
      LIMIT 1;
    `);
  
    return {
      content: [
        {
          type: "text",
          text: JSON.stringify(
            {
              table_name: sanitizedTableName,
              raster_column: sanitizedRasterColumn,
              raster_info: result.rows[0] || null,
            },
            null,
            2
          ),
        },
      ],
    };
  }

• server.ts:120-123 (schema)

  Input schema validation using Zod for 'raster-info' tool: requires table_name, optional raster_column defaulting to 'rast'.

  const RasterInfoSchema = z.object({
    table_name: z.string(),
    raster_column: z.string().optional().default("rast"),
  });

• server.ts:921-934 (registration)

  Registration of 'raster-info' tool in the ListTools handler, providing name, description, and input schema.

    name: "raster-info",
    description: "Raster verisinin bilgilerini al",
    inputSchema: {
      type: "object",
      properties: {
        table_name: { type: "string", description: "Raster tablosu adı" },
        raster_column: {
          type: "string",
          description: "Raster kolonu (varsayılan: rast)",
        },
      },
      required: ["table_name"],
    },
  },