AI_SQL / mcp_server
mgbam's picture
Update mcp_server
ba3687a verified
raw
history blame
1.24 kB
import gradio as gr
from mcp import StdioServerParameters
from smolagents import MCPClient, CodeAgent
def respond(prompt, history=[]):
"""Send the user prompt to the MCP‑powered agent and return the reply."""
# Launch the MCP server as a subprocess (stdio transport)
params = StdioServerParameters(command="python", args=["mcp_server.py"])
with MCPClient(params) as tools:
# Replace "gpt-4" with your preferred local or API‑based LLM
agent = CodeAgent(tools=tools, model="gpt-4")
result = agent.run(prompt)
history.append((prompt, result))
return history, history
with gr.Blocks() as demo:
chat_history = gr.State([])
chatbot = gr.Chatbot(label="Enterprise SQL Agent")
prompt_box = gr.Textbox(
show_label=False,
placeholder="Ask questions like: 'Who are my inactive Northeast customers?'",
)
prompt_box.submit(respond, [prompt_box, chat_history], [chatbot, chat_history])
gr.Markdown(
"""
### Example Prompts
- Who are my Northeast customers who haven’t ordered in 6 months?
- List customers sorted by last order date.
- Find clients from the West with recent orders.
"""
)
demo.launch()