Skip to main content
Glama
pinax-network

The Graph Token API MCP

utils.ts1.41 kB
// From https://github.com/ClickHouse/clickhouse-js/blob/6e26010036bc108c835d16c5a4904c6dc6039e70/packages/client-common/src/data_formatter/format_query_params.ts#L5 // Allows for safe quoting of variables in SQL queries when not able to use query params import { formatQueryParams } from "@clickhouse/client-common"; import { Progress, UserError } from "fastmcp"; import { makeQuery } from "../clickhouse/makeQuery.js"; import { config } from "./config.js"; export async function runSQLMCP( sql: string, reportProgress?: (progress: Progress) => Promise<void>, include_statistics: boolean = false ): Promise<string> { let response; try { response = await makeQuery(sql, {}, { username: config.username, password: config.password }, reportProgress); } catch (error) { throw new UserError(`Error while running SQL query: ${error}`); } if (response.data && response.data.length > 0) { const json = JSON.stringify(include_statistics ? { data: response.data, statistics: response.statistics } : response.data); if (!json) throw new UserError(`Error parsing SQL query response to JSON`); return json; } else { throw new UserError(`SQL query response didn't contain any data.`); } } export function escapeSQL(value: string): string { return `"${formatQueryParams({ value })}"`; // Wrap in double quotes }

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/pinax-network/mcp-token-api'

If you have feedback or need assistance with the MCP directory API, please join our Discord server