list_stored_procedures

List all stored procedures in a database.

Part of the SQL Server MCP (macOS) MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.

@tharanabopearachchi/sql-server-mcp-macos Read

// WHEN AI AGENTS USE THIS TOOL

AI agents call list_stored_procedures to retrieve information from SQL Server MCP (macOS) without modifying any data. This is common in research, monitoring, and reporting workflows where the agent needs context before taking action. Because read operations don't change state, they are generally safe to allow without restrictions -- but you may still want rate limits to control API costs.

// WHY ENFORCE A POLICY ON LIST_STORED_PROCEDURES

Even though list_stored_procedures only reads data, uncontrolled read access can leak sensitive information or rack up API costs. An agent caught in a retry loop could make thousands of calls per minute. A rate limit gives you a safety net without blocking legitimate use.

// RECOMMENDED POLICY

Read-only tools are safe to allow by default. No rate limit needed unless you want to control costs.

sql-server-mcp-macos.yaml

tools:
  list_stored_procedures:
    rules:
      - action: allow

See the full SQL Server MCP (macOS) policy for all 12 tools.

// DETAILS

Tool Name list_stored_procedures

Category Read

MCP Server SQL Server MCP (macOS) MCP Server

Risk Level Low

// MORE SQL SERVER MCP (MACOS) TOOLS

Execute execute_query Read describe_table Read find_column_usage Read get_database_overview Read get_procedure_definition Read get_related_tables Read get_table_relationships Read list_databases

View all 12 tools →

// WHAT CAN GO WRONG

Agents calling read-class tools like list_stored_procedures have been implicated in these attack patterns. Read the full case and prevention policy for each:

Browse the full MCP Attack Database →

// OTHER READ TOOLS ACROSS MCP SERVERS

Other tools in the Read risk category across the catalogue. The same policy patterns (rate-limit, allow) apply to each.

Open Library MCP Server get_author_info Open Library MCP Server get_author_photo Open Library MCP Server get_authors_by_name Open Library MCP Server get_book_by_id Open Library MCP Server get_book_by_title Open Library MCP Server get_book_cover

// RELATED READING

// FAQ

What does the list_stored_procedures tool do? +

List all stored procedures in a database.. It is categorised as a Read tool in the SQL Server MCP (macOS) MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on list_stored_procedures? +

Add a rule in your Intercept YAML policy under the tools section for list_stored_procedures. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the SQL Server MCP (macOS) MCP server.

What risk level is list_stored_procedures? +

list_stored_procedures is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit list_stored_procedures? +

Yes. Add a rate_limit block to the list_stored_procedures rule in your Intercept policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block list_stored_procedures completely? +

Set action: deny in the Intercept policy for list_stored_procedures. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides list_stored_procedures? +

list_stored_procedures is provided by the SQL Server MCP (macOS) MCP server (@tharanabopearachchi/sql-server-mcp-macos). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

list_stored_procedures

Enforce policies on SQL Server MCP (macOS)