MCP-Turso

Instructions

Implementation Reference

• src/index.ts:66-81 (registration)

  Registration of the 'get_db_schema' tool, which calls the dbSchema helper function from utils.ts and formats the result as JSON content.

  server.addTool({
  	name: "get_db_schema",
  	description: "Get the schema for all tables in the database",
  	parameters: z.object({}),
  	execute: async () => {
  		try {
  			const schema = await dbSchema(db);
  			return content(JSON.stringify({ schema }, null, 2));
  		} catch (error) {
  			return content(
  				`Error getting schema: ${error instanceof Error ? error.message : String(error)}`,
  				true,
  			);
  		}
  	},
  });

• src/utils.ts:33-40 (handler)

  Core handler logic for retrieving SQL CREATE statements for all user tables from sqlite_master.

  export async function dbSchema(client: Client): Promise<string[]> {
  	const result = await client.execute({
  		sql: "SELECT sql FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'",
  		args: [],
  	});
  
  	return result.rows.map((row) => row.sql as string);
  }