mcp-turso-cloud

Instructions

Implementation Reference

• src/tools/handler.ts:190-200 (handler)

  Handler function for the list_tables tool that resolves the database context, calls the database client helper, and formats the response.

  async ({ database }) => {
  	try {
  		const database_name = resolve_database_name(database);
  		if (database) set_current_database(database);
  
  		const tables = await database_client.list_tables(database_name);
  		return create_tool_response({ database: database_name, tables });
  	} catch (error) {
  		return create_tool_error_response(error);
  	}
  },

• src/tools/handler.ts:32-34 (schema)

  Zod input schema used by the list_tables tool: optional database name (uses current context if omitted).

  const DatabaseOnlySchema = z.object({
  	database: z.string().optional().describe('Database name (optional, uses context if not provided)'),
  });

• src/tools/handler.ts:184-189 (registration)

  Registration of the list_tables tool with MCP server, specifying name, description, and input schema.

  server.tool(
  	{
  		name: 'list_tables',
  		description: 'Lists all tables in a database',
  		schema: DatabaseOnlySchema,
  	},

• src/clients/database.ts:88-115 (helper)

  Core helper function that creates a read-only database client and queries sqlite_schema to retrieve non-system table names.

  export async function list_tables(
  	database_name: string,
  ): Promise<string[]> {
  	try {
  		const client = await get_database_client(
  			database_name,
  			'read-only',
  		);
  
  		// Query the sqlite_schema table to get all tables
  		const result = await client.execute({
  			sql: `SELECT name FROM sqlite_schema 
              WHERE type = 'table' 
              AND name NOT LIKE 'sqlite_%'
              ORDER BY name`,
  		});
  
  		// Extract table names from the result
  		return result.rows.map((row) => row.name as string);
  	} catch (error) {
  		throw new TursoApiError(
  			`Failed to list tables for database ${database_name}: ${
  				(error as Error).message
  			}`,
  			500,
  		);
  	}
  }