Warp SQL Server MCP

Instructions

Implementation Reference

• lib/tools/handlers/database-tools.js:44-71 (handler)

  Core handler function that constructs and executes SQL query to list tables in a database/schema
  async listTables(database = null, schema = 'dbo') { let query; if (database) { query = ` SELECT t.TABLE_SCHEMA as schema_name, t.TABLE_NAME as table_name, t.TABLE_TYPE as table_type FROM [${database}].INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_SCHEMA = '${schema}' ORDER BY t.TABLE_SCHEMA, t.TABLE_NAME `; } else { query = ` SELECT t.TABLE_SCHEMA as schema_name, t.TABLE_NAME as table_name, t.TABLE_TYPE as table_type FROM INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_SCHEMA = '${schema}' ORDER BY t.TABLE_SCHEMA, t.TABLE_NAME `; } const result = await this.executeQuery(query, 'list_tables'); return this.formatResults(result); }
• index.js:261-264 (registration)

  Tool dispatch/registration in the main MCP server switch statement, calling the databaseTools handler
  case 'list_tables': return { content: await this.databaseTools.listTables(args.database, args.schema) };
• lib/tools/tool-registry.js:25-36 (schema)

  Tool schema definition including input validation schema for list_tables
  name: 'list_tables', description: 'List all tables in a specific database', inputSchema: { type: 'object', properties: { database: { type: 'string', description: 'Database name (optional, uses current database if not specified)' }, schema: { type: 'string', description: 'Schema name (optional, defaults to dbo)' } } }
• index.js:241-242 (registration)

  Registration of the tool list handler which provides all tools including list_tables via tool-registry.js
  this.server.setRequestHandler(ListToolsRequestSchema, async () => ({ tools: getAllTools()
• index.js:527-532 (handler)

  Wrapper handler method on the main server class for testing/compatibility purposes, delegates to databaseTools.listTables
  async listTables(...args) { try { return { content: await this.databaseTools.listTables(...args) }; } catch (error) { throw new McpError(ErrorCode.InternalError, error.message); }