You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "aminghadersohi (via GitHub)" <gi...@apache.org> on 2026/05/20 22:44:41 UTC
[PR] feat(mcp): add list and get tools for saved queries and query history [superset]
aminghadersohi opened a new pull request, #40301:
URL: https://github.com/apache/superset/pull/40301
### SUMMARY
Adds four new MCP tools across two new domains (`saved_query/` and `query/`):
- **`list_saved_queries`** — List saved SQL queries owned by the current user with filtering (label, db_id, schema), search, and pagination
- **`get_saved_query_info`** — Get saved query details by numeric ID or UUID
- **`list_queries`** — List SQL query history with filtering (status, database_id, schema), defaulting to most-recent-first (ordered by `start_time` desc, page_size 25)
- **`get_query_info`** — Get query history details by numeric ID
Both domains follow the existing `database/`, `dataset/`, `chart/`, and `dashboard/` patterns: `ModelListCore`/`ModelGetInfoCore` for reuse, Pydantic schemas with field-level serialization context, `@tool` decorators with RBAC, and `event_logger` instrumentation.
### BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF
N/A — backend API tools only
### TESTING INSTRUCTIONS
```bash
# Run unit tests for the new tools
pytest tests/unit_tests/mcp_service/saved_query/
pytest tests/unit_tests/mcp_service/query/
```
### ADDITIONAL INFORMATION
- [ ] Has associated issue:
- [ ] Required feature flags:
- [ ] Changes UI
- [ ] Includes DB Migration
- [x] Introduces new feature or API
- [ ] Removes existing feature or API
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "aminghadersohi (via GitHub)" <gi...@apache.org>.
aminghadersohi commented on PR #40301:
URL: https://github.com/apache/superset/pull/40301#issuecomment-4514742730
Closing in favor of #40346 (branch renamed to follow amin/feature-description convention).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "codecov[bot] (via GitHub)" <gi...@apache.org>.
codecov[bot] commented on PR #40301:
URL: https://github.com/apache/superset/pull/40301#issuecomment-4503276408
## [Codecov](https://app.codecov.io/gh/apache/superset/pull/40301?dropdown=coverage&src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) Report
:x: Patch coverage is `67.11409%` with `98 lines` in your changes missing coverage. Please review.
:white_check_mark: Project coverage is 55.39%. Comparing base ([`68c145a`](https://app.codecov.io/gh/apache/superset/commit/68c145adc3610283a2c695c0a2f0b5cb10ee0118?dropdown=coverage&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache)) to head ([`89aa7b3`](https://app.codecov.io/gh/apache/superset/commit/89aa7b329a01baf47ce6ea19c6fb39b28303d375?dropdown=coverage&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache)).
:warning: Report is 2 commits behind head on master.
| [Files with missing lines](https://app.codecov.io/gh/apache/superset/pull/40301?dropdown=coverage&src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | Patch % | Lines |
|---|---|---|
| [superset/mcp\_service/query/tool/list\_queries.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fquery%2Ftool%2Flist_queries.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2UvcXVlcnkvdG9vbC9saXN0X3F1ZXJpZXMucHk=) | 33.33% | [20 Missing :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
| [...mcp\_service/saved\_query/tool/list\_saved\_queries.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fsaved_query%2Ftool%2Flist_saved_queries.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2Uvc2F2ZWRfcXVlcnkvdG9vbC9saXN0X3NhdmVkX3F1ZXJpZXMucHk=) | 33.33% | [20 Missing :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
| [superset/mcp\_service/query/schemas.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fquery%2Fschemas.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2UvcXVlcnkvc2NoZW1hcy5weQ==) | 83.15% | [15 Missing and 1 partial :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
| [superset/mcp\_service/saved\_query/schemas.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fsaved_query%2Fschemas.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2Uvc2F2ZWRfcXVlcnkvc2NoZW1hcy5weQ==) | 82.02% | [15 Missing and 1 partial :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
| [superset/mcp\_service/query/tool/get\_query\_info.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fquery%2Ftool%2Fget_query_info.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2UvcXVlcnkvdG9vbC9nZXRfcXVlcnlfaW5mby5weQ==) | 43.47% | [13 Missing :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
| [...p\_service/saved\_query/tool/get\_saved\_query\_info.py](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&filepath=superset%2Fmcp_service%2Fsaved_query%2Ftool%2Fget_saved_query_info.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#diff-c3VwZXJzZXQvbWNwX3NlcnZpY2Uvc2F2ZWRfcXVlcnkvdG9vbC9nZXRfc2F2ZWRfcXVlcnlfaW5mby5weQ==) | 43.47% | [13 Missing :warning: ](https://app.codecov.io/gh/apache/superset/pull/40301?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) |
> :exclamation: There is a different number of reports uploaded between BASE (68c145a) and HEAD (89aa7b3). Click for more details.
>
> <details><summary>HEAD has 9 uploads less than BASE</summary>
>
>| Flag | BASE (68c145a) | HEAD (89aa7b3) |
>|------|------|------|
>|python|10|1|
></details>
<details><summary>Additional details and impacted files</summary>
```diff
@@ Coverage Diff @@
## master #40301 +/- ##
==========================================
- Coverage 64.18% 55.39% -8.80%
==========================================
Files 2591 2599 +8
Lines 138455 138753 +298
Branches 32118 32130 +12
==========================================
- Hits 88871 76860 -12011
- Misses 48052 61226 +13174
+ Partials 1532 667 -865
```
| [Flag](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | Coverage Δ | |
|---|---|---|
| [hive](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `?` | |
| [mysql](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `?` | |
| [postgres](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `?` | |
| [presto](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `41.21% <67.11%> (+0.12%)` | :arrow_up: |
| [python](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `41.21% <67.11%> (-19.36%)` | :arrow_down: |
| [sqlite](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `?` | |
| [unit](https://app.codecov.io/gh/apache/superset/pull/40301/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) | `?` | |
Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#carryforward-flags-in-the-pull-request-comment) to find out more.
</details>
[:umbrella: View full report in Codecov by Sentry](https://app.codecov.io/gh/apache/superset/pull/40301?dropdown=coverage&src=pr&el=continue&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache).
:loudspeaker: Have feedback on the report? [Share it here](https://about.codecov.io/codecov-pr-comment-feedback/?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache).
<details><summary> :rocket: New features to boost your workflow: </summary>
- :snowflake: [Test Analytics](https://docs.codecov.com/docs/test-analytics): Detect flaky tests, report on failures, and find test suite problems.
- :package: [JS Bundle Analysis](https://docs.codecov.com/docs/javascript-bundle-analysis): Save yourself from yourself by tracking and limiting bundle sizes in JS merges.
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "bito-code-review[bot] (via GitHub)" <gi...@apache.org>.
bito-code-review[bot] commented on code in PR #40301:
URL: https://github.com/apache/superset/pull/40301#discussion_r3287153289
##########
superset/mcp_service/saved_query/tool/list_saved_queries.py:
##########
@@ -0,0 +1,159 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+
+"""
+List saved queries FastMCP tool
+
+This module contains the FastMCP tool for listing saved SQL queries
+with filtering, search, and pagination.
+"""
+
+import logging
+
+from fastmcp import Context
+from superset_core.mcp.decorators import tool, ToolAnnotations
+
+from superset.extensions import event_logger
+from superset.mcp_service.mcp_core import ModelListCore
+from superset.mcp_service.saved_query.schemas import (
+ ALL_SAVED_QUERY_COLUMNS,
+ DEFAULT_SAVED_QUERY_COLUMNS,
+ ListSavedQueriesRequest,
+ SavedQueryError,
+ SavedQueryFilter,
+ SavedQueryInfo,
+ SavedQueryList,
+ serialize_saved_query_object,
+ SORTABLE_SAVED_QUERY_COLUMNS,
+)
+
+logger = logging.getLogger(__name__)
+
+_DEFAULT_LIST_SAVED_QUERIES_REQUEST = ListSavedQueriesRequest()
+
+
+@tool(
+ tags=["core"],
+ class_permission_name="SavedQuery",
+ annotations=ToolAnnotations(
+ title="List saved queries",
+ readOnlyHint=True,
+ destructiveHint=False,
+ ),
+)
+async def list_saved_queries(
+ request: ListSavedQueriesRequest | None = None,
+ ctx: Context | None = None,
+) -> SavedQueryList | SavedQueryError:
+ """List saved SQL queries with filtering and search.
+
+ Returns saved queries owned by the current user, including label, SQL,
+ database ID, and schema.
+
+ Sortable columns for order_column: id, label, db_id, schema,
+ changed_on, created_on
+ """
+ if ctx is None:
+ raise RuntimeError("FastMCP context is required for list_saved_queries")
+
+ request = request or _DEFAULT_LIST_SAVED_QUERIES_REQUEST.model_copy(deep=True)
+
+ await ctx.info(
+ "Listing saved queries: page=%s, page_size=%s, search=%s"
+ % (
+ request.page,
+ request.page_size,
+ request.search,
+ )
+ )
+ await ctx.debug(
+ "Saved query listing parameters: filters=%s, order_column=%s, "
+ "order_direction=%s, select_columns=%s"
+ % (
+ request.filters,
+ request.order_column,
+ request.order_direction,
+ request.select_columns,
+ )
+ )
+
+ try:
+ from superset.daos.query import SavedQueryDAO
+
+ def _serialize_saved_query(
+ obj: object, cols: list[str] | None
+ ) -> SavedQueryInfo | None:
+ return serialize_saved_query_object(obj)
+
+ list_tool = ModelListCore(
+ dao_class=SavedQueryDAO,
+ output_schema=SavedQueryInfo,
+ item_serializer=_serialize_saved_query,
+ filter_type=SavedQueryFilter,
+ default_columns=DEFAULT_SAVED_QUERY_COLUMNS,
+ search_columns=["label", "description", "sql"],
+ list_field_name="saved_queries",
+ output_list_schema=SavedQueryList,
+ all_columns=ALL_SAVED_QUERY_COLUMNS,
+ sortable_columns=SORTABLE_SAVED_QUERY_COLUMNS,
+ logger=logger,
+ )
+
+ with event_logger.log_context(action="mcp.list_saved_queries.query"):
+ result = list_tool.run_tool(
+ filters=request.filters,
+ search=request.search,
+ select_columns=request.select_columns,
+ order_column=request.order_column,
+ order_direction=request.order_direction,
+ page=max(request.page - 1, 0),
+ page_size=request.page_size,
+ )
Review Comment:
<div>
<div id="suggestion">
<div id="issue"><b>Missing ownership filter params</b></div>
<div id="fix">
Add `created_by_me` and `owned_by_me` parameters to the `list_tool.run_tool()` call and extend the ListSavedQueriesRequest schema to support these flags, enabling ownership-based filtering.
</div>
</div>
<small><i>Code Review Run #a1ef76</i></small>
</div>
---
Should Bito avoid suggestions like this for future reviews? (<a href=https://alpha.bito.ai/home/ai-agents/review-rules>Manage Rules</a>)
- [ ] Yes, avoid them
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "bito-code-review[bot] (via GitHub)" <gi...@apache.org>.
bito-code-review[bot] commented on PR #40301:
URL: https://github.com/apache/superset/pull/40301#issuecomment-4516750270
AI Code Review is in progress (usually takes 3 to 15 minutes unless it's a very large PR).
<details>
<summary>
Bito Usage Guide
</summary>
**Commands**
Type the following command in the pull request comment and save the comment.
- `/review` - Manually triggers a full AI review.
- `/pause` - Pauses automatic reviews on this pull request.
- `/resume` - Resumes automatic reviews.
- `/resolve` - Marks all Bito-posted review comments as resolved.
- `/abort` - Cancels all in-progress reviews.
Refer to the <a href="https://docs.bito.ai/bito-dev-agents/ai-code-review-agent/available-commands" target="_blank" rel="noopener noreferrer">documentation</a> for additional commands.
**Configuration**
This repository uses `Superset` You can customize the agent settings <a href="https://alpha.bito.ai/home/ai-agents/code-review-agent" target="_blank" rel="noopener noreferrer">here</a> or contact your Bito workspace admin at evan@preset.io.
**Documentation & Help**
- <a href="https://docs.bito.ai/bito-dev-agents/ai-code-review-agent/getting-started/install-run-using-bito-cloud/create-or-customize-an-agent-instance" target="_blank" rel="noopener noreferrer">Customize agent settings</a>
- <a href="https://docs.bito.ai/bito-dev-agents/ai-code-review-agent/implementing-custom-code-review-rules" target="_blank" rel="noopener noreferrer">Review rules</a>
- <a href="https://docs.bito.ai/bito-dev-agents/ai-code-review-agent" target="_blank" rel="noopener noreferrer">General documentation</a>
- <a href="https://docs.bito.ai/bito-dev-agents/ai-code-review-agent/faqs" target="_blank" rel="noopener noreferrer">FAQ</a>
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "bito-code-review[bot] (via GitHub)" <gi...@apache.org>.
bito-code-review[bot] commented on PR #40301:
URL: https://github.com/apache/superset/pull/40301#issuecomment-4503244521
AI Code Review is in progress (usually takes 3 to 15 minutes unless it's a very large PR).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [PR] feat(mcp): add list and get tools for saved queries and query history [superset]
Posted by "aminghadersohi (via GitHub)" <gi...@apache.org>.
aminghadersohi closed pull request #40301: feat(mcp): add list and get tools for saved queries and query history
URL: https://github.com/apache/superset/pull/40301
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org