/**
* MySQL Resource - Capabilities
*
* Provides server version, available features, and tool categories.
*/
import type { MySQLAdapter } from "../MySQLAdapter.js";
import type {
ResourceDefinition,
RequestContext,
} from "../../../types/index.js";
import {
TOOL_GROUPS,
META_GROUPS,
getMetaGroupInfo,
getToolGroupInfo,
} from "../../../filtering/ToolFilter.js";
export function createCapabilitiesResource(
adapter: MySQLAdapter,
): ResourceDefinition {
return {
uri: "mysql://capabilities",
name: "Server Capabilities",
title: "MySQL Server Capabilities",
description:
"MySQL server version, extensions, and available tool categories",
mimeType: "application/json",
annotations: {
audience: ["user", "assistant"],
priority: 0.9,
},
handler: async (_uri: string, _context: RequestContext) => {
// Get server version
const versionResult = await adapter.executeQuery(
"SELECT VERSION() as version",
);
const version =
(versionResult.rows?.[0]?.["version"] as string) ?? "unknown";
// Parse major version for feature detection (handles 8.x, 9.x, 10.x+)
const majorVersion = parseInt(version.split(".")[0] ?? "0", 10) || 0;
const features = {
json: majorVersion >= 8 || version.startsWith("5.7"),
fulltext: true,
partitioning: true,
replication: true,
gtid:
majorVersion >= 8 ||
version.startsWith("5.6") ||
version.startsWith("5.7"),
};
// Get tool groups and meta-groups info
const toolGroupList = getToolGroupInfo();
const metaGroupList = getMetaGroupInfo();
return {
server: {
version,
features,
},
toolCategoryCount: Object.keys(TOOL_GROUPS).length,
metaGroupCount: Object.keys(META_GROUPS).length,
toolGroups: toolGroupList,
metaGroups: metaGroupList,
};
},
};
}
