数据库访问服务

version : 1.0.0

db_tables

List all tables in the database, optionally filtered by schema. Returns qualified table names.

db_url(string)

schema(string)

结果(Result)

db_describe_table

Get column information for a specific table including column names, data types, and nullability.

db_url(string)

schema(string)

*table(string)

结果(Result)

db_execute

Execute a SQL statement. Supports SELECT (read), INSERT/UPDATE/DELETE (write if enabled), and DDL (if enabled). Use named parameters with :param syntax.

db_url(string)

*sql(string)

args(object)

allow_write(boolean)

row_limit(number)

结果(Result)

db_explain

Get query execution plan and performance information using EXPLAIN. Helps analyze query performance and optimization opportunities.

db_url(string)

*sql(string)

args(object)

analyze(boolean)

结果(Result)