AI Chat should have a "Propose action only" instead of executing immediately

Open
#9,826 1 comment 1 reaction 0 assignees View on GitHub

Maintainers usually reply within 2 days

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
48/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Quiet
Tech stack
postgresql, python
Domain
ai, databases, security

Research direction

Start by tracing the AI Chat command flow that currently mounts and executes SQL, then identify where a disabled or proposal-only mode would be represented. Verify that read and destructive requests both produce a proposal without execution, and confirm the behavior against the described invoice-query examples and the vLLM/Qwen setup.

Written by the indexing model from the issue text.

Description

Feature

Describe the solution you'd like

I would like to enable/disable the automatic execution of commands on AI Chat. Currently, AFAIK, when the user asks "tell me the last 10 invoices", the chat mount AND execute the query. It's highly insecure if user says "delete last 10 invoices". In the "Disabled mode" the AI Chat never executes a command, just propose one.

Describe alternatives you've considered

Start the prompt with "Do not execute the command, only show SQL for: ..."

Additional context

Using version 9.14 with vllm and Qwen 3.5 model.

Dominant language
Python
Stars
3.9k
Forks
922
Avg merge
2d 3h
Merged PRs (30d)
33

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from pgadmin-org/pgadmin4

All issues in pgadmin-org/pgadmin4

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.