查询集成连接器和API配置(v3_openapi数据库)。使用 exec_sql 工具执行查询。
Inherits all available tools
Additional assets for this skill
This skill inherits all available tools. When active, it can use any tool Claude has access to.
COMMON.md参考:通用规范
所有查询使用 exec_sql 工具执行,参数替换为实际值。
重要:在执行 SQL 前,必须先打印出完整的目标 SQL 语句,然后再使用 exec_sql 工具执行。
重要:执行 SQL 后,必须对查询结果进行结构化展示:
参数:
{org_id} - 租户ID-- 按租户查询集成连接器
SELECT * FROM v3_openapi.integrated_connector WHERE org_id = {org_id} and deleted_at = 0;
参数:
{org_id} - 租户ID{interface_id} - API接口ID{connector_id} - 连接器ID-- 按租户查询API接口列表
SELECT * FROM v3_openapi.integrated_connector_api WHERE org_id = {org_id} and deleted_at = 0;
-- 按接口ID查询API详情
SELECT * FROM v3_openapi.integrated_connector_api WHERE org_id = {org_id} AND id = {interface_id} and deleted_at = 0;
-- 按连接器ID查询API接口
SELECT * FROM v3_openapi.integrated_connector_api WHERE integrated_connector_id = {connector_id} and deleted_at = 0;
参数:
{org_id} - 租户ID{interface_id} - API接口ID{connector_id} - 连接器ID-- 按接口ID查询字段配置
SELECT * FROM v3_openapi.integrated_connector_api_field WHERE org_id = {org_id} AND interface_id = {interface_id} and deleted_at = 0 order by req_or_res, id;
-- 按连接器ID查询所有API的字段
SELECT * FROM v3_openapi.integrated_connector_api_field
WHERE org_id = {org_id} AND interface_id IN (
SELECT id FROM v3_openapi.integrated_connector_api
WHERE org_id = {org_id} AND integrated_connector_id = {connector_id} and deleted_at = 0
) and deleted_at = 0
order by interface_id, req_or_res, id;
{参数名}都需要替换为实际值deleted_at = 0条件exec_sql 执行DESC table_name 或 SHOW COLUMNS FROM table_name 查询