/**
* MySQL Resource - Spatial
*/
import type { MySQLAdapter } from "../MySQLAdapter.js";
import type {
ResourceDefinition,
RequestContext,
} from "../../../types/index.js";
export function createSpatialResource(
adapter: MySQLAdapter,
): ResourceDefinition {
return {
uri: "mysql://spatial",
name: "Spatial Columns",
title: "MySQL Spatial/GIS Columns",
description: "Spatial columns and indexes in the database",
mimeType: "application/json",
annotations: {
audience: ["user", "assistant"],
priority: 0.5,
},
handler: async (_uri: string, _context: RequestContext) => {
// Get spatial columns
const columnsResult = await adapter.executeQuery(`
SELECT
TABLE_SCHEMA as schema_name,
TABLE_NAME as table_name,
COLUMN_NAME as column_name,
DATA_TYPE as data_type,
SRS_ID as srid
FROM information_schema.COLUMNS
WHERE DATA_TYPE IN ('geometry', 'point', 'linestring', 'polygon',
'multipoint', 'multilinestring', 'multipolygon', 'geometrycollection')
AND TABLE_SCHEMA = DATABASE()
ORDER BY TABLE_NAME, COLUMN_NAME
`);
// Get spatial indexes
const indexesResult = await adapter.executeQuery(`
SELECT
TABLE_NAME as table_name,
INDEX_NAME as index_name,
COLUMN_NAME as column_name
FROM information_schema.STATISTICS
WHERE INDEX_TYPE = 'SPATIAL'
AND TABLE_SCHEMA = DATABASE()
ORDER BY TABLE_NAME, INDEX_NAME
`);
return {
spatialColumnCount: columnsResult.rows?.length ?? 0,
spatialColumns: columnsResult.rows ?? [],
spatialIndexCount: indexesResult.rows?.length ?? 0,
spatialIndexes: indexesResult.rows ?? [],
};
},
};
}
