feat(tools/postgres-list-active-queries): add new postgres-list-active-queries tool#1400
Merged
Merged
Conversation
averikitsch
reviewed
Sep 10, 2025
averikitsch
left a comment
Contributor
There was a problem hiding this comment.
Do you have an example or demo of this working?
Contributor
|
/gcbrun |
averikitsch
requested changes
Sep 10, 2025
averikitsch
reviewed
Sep 10, 2025
ca87804 to
1e3d9e2
Compare
postgres-list-active-queries tool type in MCP Toolbox
postgres-list-active-queries tool type in MCP Toolboxpostgres-list-active-queries tool type in MCP Toolbox
1c838b6 to
6d6073c
Compare
6d6073c to
ce34c88
Compare
Contributor
|
/gcbrun |
postgres-list-active-queries tool type in MCP Toolboxpostgres-list-active-queries tool
postgres-list-active-queries toolpostgres-list-active-queries tool
Yuan325
requested changes
Sep 13, 2025
Yuan325
left a comment
Contributor
There was a problem hiding this comment.
Hi, please let me know if you would like me to clarify any of the requested changes :) Thank you!
58f8e21 to
c219f36
Compare
Contributor
Contributor
|
/gcbrun |
averikitsch
approved these changes
Sep 16, 2025
2567ae4 to
669d308
Compare
Contributor
|
/gcbrun |
578271e to
557360a
Compare
Contributor
|
/gcbrun |
Contributor
|
/gcbrun |
6 tasks
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Description
Adds a PostgreSQL tool kind
postgres-list-active-queriesthat returns the top N currently running queries (state='active') frompg_stat_activity, ordered by longest running first. Each row includes:pid,user,database,application_name,client_addr,state,wait_event_type,wait_event,backend_start,xact_start,query_start, computedduration, andquery(SQL text).Parameters supported
min_duration(optional) — only include queries running at least this long (e.g., "1 minute", "2 seconds").exclude_application_names(optional) — comma-separated list of application_name values to exclude (e.g., "psql,pgAdmin 4,my-batch").limit(optional) — max rows to return (default 50).Test Output
PR Checklist
CONTRIBUTING.md
bug/issue
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
!if this involve a breaking change