🔒 need help implementing mcp server and client in streamlit app

[wicked kelp]

i'm working on a streamlit app where users can input natural language to query the database, (example "is the length of a hospital stay related to age"). database doesn't store the actual data, but the **metadata **of the table (column types, column descriptions etc) the json metadata of each table is stored as a record in a mongoDB database. attached a reference

currently stuck on the mcp client / server that uses gemini flash 2.0.

i was thinking of some tools like (1) get table names from mongoDB database (2) get the schema of a table, which is stored in a json (3) get relevant columns that can answer the question based on description etc.

something like this server attached but i am wholly stuck and chatgpt is clueless too

any kind of help will be good thank you i'm getting pretty desperate hahahah

[hoary spade]

Click here to see this code in our pastebin.

[hoary spade]

@wicked kelp

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[hoary spade]

@wicked kelp

Python help channel closed for inactivity

This help channel has been closed. Feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.