You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by mi...@apache.org on 2026/04/01 09:05:55 UTC
(superset) 01/01: fix(mcp): improve execute_sql response-too-large error to suggest limit parameter
This is an automated email from the ASF dual-hosted git repository.
misterg pushed a commit to branch amin/execute-sql-suggest-limit
in repository https://gitbox.apache.org/repos/asf/superset.git
commit c4243d6b5ce8fb0ec6cb7faca41ff84ced9eee48
Author: Amin Ghadersohi <am...@gmail.com>
AuthorDate: Wed Apr 1 05:05:27 2026 -0400
fix(mcp): improve execute_sql response-too-large error to suggest limit parameter
When execute_sql responses exceed the token limit, the error message now
suggests both adding a SQL LIMIT clause and using the tool's limit
parameter. Previously only the SQL LIMIT was mentioned, and the general
"add a limit" suggestion was skipped for execute_sql entirely.
---
superset/mcp_service/utils/token_utils.py | 13 +++++++++++--
.../unit_tests/mcp_service/utils/test_token_utils.py | 20 +++++++++++++++++++-
2 files changed, 30 insertions(+), 3 deletions(-)
diff --git a/superset/mcp_service/utils/token_utils.py b/superset/mcp_service/utils/token_utils.py
index b7f12a2c1cb..d4891634a8e 100644
--- a/superset/mcp_service/utils/token_utils.py
+++ b/superset/mcp_service/utils/token_utils.py
@@ -220,6 +220,11 @@ def generate_size_reduction_suggestions(
f"Add a 'limit' or 'page_size' parameter (suggested: 10-25 items) "
f"to reduce response size by ~{reduction_pct}%"
)
+ elif tool_name == "execute_sql":
+ suggestions.append(
+ f"Use the 'limit' parameter (e.g., limit=100) to cap the number "
+ f"of rows returned — need ~{reduction_pct}% reduction"
+ )
# Suggestion 2: Use select_columns to reduce fields
current_columns = query_params.get("select_columns") or query_params.get("columns")
@@ -348,9 +353,13 @@ def _get_tool_specific_suggestions(
elif tool_name == "execute_sql":
suggestions.append(
- "Add LIMIT clause to your SQL query to restrict the number of rows "
- "(e.g., SELECT * FROM table LIMIT 100)"
+ "Add a LIMIT clause to your SQL query (e.g., SELECT * FROM table LIMIT 100)"
)
+ if not query_params.get("limit"):
+ suggestions.append(
+ "Use the execute_sql 'limit' parameter to cap rows returned "
+ "(e.g., limit=100) — this overrides any SQL LIMIT clause"
+ )
elif tool_name in ("get_chart_info", "get_dashboard_info", "get_dataset_info"):
suggestions.append(
diff --git a/tests/unit_tests/mcp_service/utils/test_token_utils.py b/tests/unit_tests/mcp_service/utils/test_token_utils.py
index 649536019bb..a451b086b37 100644
--- a/tests/unit_tests/mcp_service/utils/test_token_utils.py
+++ b/tests/unit_tests/mcp_service/utils/test_token_utils.py
@@ -222,7 +222,25 @@ class TestGenerateSizeReductionSuggestions:
estimated_tokens=50000,
token_limit=25000,
)
- assert any("LIMIT" in s or "limit" in s.lower() for s in suggestions)
+ combined = " ".join(suggestions)
+ # Should suggest SQL LIMIT clause
+ assert "LIMIT" in combined
+ # Should suggest the tool's limit parameter
+ assert "'limit' parameter" in combined.lower() or "limit=" in combined.lower()
+
+ def test_execute_sql_with_limit_param_no_duplicate_suggestion(self) -> None:
+ """When limit param is already set, should not suggest adding it again."""
+ suggestions = generate_size_reduction_suggestions(
+ tool_name="execute_sql",
+ params={"sql": "SELECT * FROM table", "limit": 500},
+ estimated_tokens=50000,
+ token_limit=25000,
+ )
+ combined = " ".join(suggestions)
+ # Should still suggest SQL LIMIT
+ assert "LIMIT" in combined
+ # Should suggest reducing the existing limit (from general suggestion)
+ assert "500" in combined or "limit" in combined.lower()
def test_tool_specific_suggestions_list_charts(self) -> None:
"""Should provide chart-specific suggestions for list_charts."""