List all database sources available in the local metadata cache.

List all schemas for a given source.

List all tables in a given schema.

Get columns and FK relationships (inbound + outbound) for a specific table.

Return the SQL dialect for a source (e.g. 'mssql', 'snowflake').

Return every foreign key defined in a schema.

Return FK-defined direct joins between two tables (either direction). Provide table names as 'schema.table' (e.g. 'dbo.Orders').

Suggest join paths between two tables using FK graph + heuristic column matching. Results ordered by descending confidence. Table names as 'schema.table'.

Search for tables whose names contain keyword (case-insensitive).

Search for columns whose names contain column_name (case-insensitive). Optionally restrict to a single schema.

List all stored procedure names in a given schema.

Get full metadata for a stored procedure: parameters, create/modify dates, and definition.

Search for stored procedures whose names contain keyword (case-insensitive). Optionally restrict to a single schema.

Search the body (definition) of stored procedures for keyword (case-insensitive). Returns each matching procedure with a short excerpt showing the first line that contains the keyword. Optionally restrict to a single schema.

Generate a ready-to-use call template for a stored procedure.

style='sql' — EXEC statement with typed placeholders for each parameter. style='python' — pyodbc script that executes the SP and collects every result set returned by the server using cursor.nextset().

Write the stored procedure definition (SQL code only) to a file.

Refresh the local schema metadata cache by querying live databases.

THIS IS AN EXPENSIVE OPERATION — each source may take several minutes. Do NOT call automatically before reads. The cache is designed to be long-lived. Only call when:

• No cache exists yet for a source (first-time setup)

• The user explicitly says a schema has changed

Each source is throttled to one refresh per 24 hours. Set force=True ONLY when the user has confirmed recent schema changes.

Add a new database source to config.yaml and optionally test the connection.

db_type='sqlserver': url (required) -- SQLAlchemy connection URL, e.g.: "mssql+pyodbc:///?odbc_connect=DRIVER=ODBC Driver 17 for SQL Server; Server=myserver;Database=MyDB;Trusted_Connection=Yes;"

db_type='snowflake' (via SQL Server linked server + OPENQUERY): sqlserver_url (required) -- SQLAlchemy URL for the gateway SQL Server linked_server (required) -- Linked server name (e.g. "SNOWFLAKE") snowflake_database (required) -- Snowflake database (e.g. "MY_DB")

Common: include_schemas -- ["*"] for all (default), or explicit list exclude_schemas -- defaults to system schemas for the db_type test_connection -- set False to skip the live connection test

After adding, call refresh_metadata(source='') to populate the cache.