search_tables
Search database tables using keywords to find schema information and metadata across multiple data sources.
Instructions
根据关键词搜索数据库表
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keyword | Yes | 搜索关键词 | |
| source | No | 数据源类型 | auto |
Implementation Reference
- sp_database_mcp/server.py:136-152 (schema)Defines the Tool schema for 'search_tables', including input parameters: keyword (required) and source (optional: database, api, auto).Tool( name="search_tables", description="根据关键词搜索数据库表", inputSchema={ "type": "object", "properties": { "keyword": {"type": "string", "description": "搜索关键词"}, "source": { "type": "string", "enum": ["database", "api", "auto"], "description": "数据源类型", "default": "auto", }, }, "required": ["keyword"], }, ),
- sp_database_mcp/server.py:203-223 (handler)MCP tool handler for 'search_tables': validates input, calls _search_tables, formats results as Markdown list of matching tables with names, comments, and column counts.elif name == "search_tables": keyword = arguments.get("keyword") source = arguments.get("source", "auto") if not keyword: return [TextContent(type="text", text="错误：缺少搜索关键词")] tables = await _search_tables(keyword, source) if tables: output = f"找到 {len(tables)} 个匹配的表：\n\n" for table in tables: output += f"## {table.name}\n" if table.comment: output += f"**说明**: {table.comment}\n" output += f"**字段数**: {len(table.columns)}\n\n" return [TextContent(type="text", text=output)] else: return [ TextContent(type="text", text=f"未找到包含关键词 '{keyword}' 的表") ]
- sp_database_mcp/server.py:286-302 (helper)Helper function that routes search_tables call to DatabaseClient or APIClient based on source parameter, preferring database for 'auto'.async def _search_tables(keyword: str, source: str) -> List[TableInfo]: """搜索表的内部方法""" if source == "database" and db_client: return db_client.search_tables(keyword) elif source == "api" and api_client: return await api_client.search_tables(keyword) elif source == "auto": # 优先使用数据库直连 if db_client: result = db_client.search_tables(keyword) if result: return result if api_client: return await api_client.search_tables(keyword) return []
- sp_database_mcp/database.py:227-241 (handler)Core implementation of table search in DatabaseClient: lists all tables, filters by keyword in table name (case-insensitive), retrieves full TableInfo for matches.def search_tables(self, keyword: str) -> List[TableInfo]: """根据关键词搜索表""" all_tables = self.get_all_tables() matching_tables = [ table for table in all_tables if keyword.lower() in table.lower() ] result = [] for table_name in matching_tables: table_info = self.get_table_info(table_name) if table_info: result.append(table_info) return result