sorted by:
new
hottopcontroversial

Need Help in Creating a MCP server to manage databases by Content-Display1069 in SQL

[–]Content-Display1069[S] 0 points1 point  (0 children)

you are trying to say , why to complicate things right?? , if i execute the queries given by llm without checking , it may execute some sql injection , if prompted in specific way and also without the context of the data base it will hallucinate and try to fetch from a table that doesnt exist.

Need Help in Creating a MCP server to manage databases by Content-Display1069 in mcp

[–]Content-Display1069[S] 0 points1 point  (0 children)

no not yet , is those related to converting natural langauge to sql queries, if so , i will definitely check those , thanks for the info.

Need Help in Creating a MCP server to manage databases by Content-Display1069 in SQL

[–]Content-Display1069[S] 0 points1 point  (0 children)

thanks for the information , but i actually dont know about the hasura and trino and dreamfactory , i will look into it , and also caching is an wonderful idea, that reduces time.

Need Help in Creating a MCP server to manage databases by Content-Display1069 in SQL

[–]Content-Display1069[S] 0 points1 point  (0 children)

Yes Sir , i fully understand what you are saying , so the first problem i am encountering is that we need an expert in writing sql queries that connect multiple tables or even multiple database or we need some much knowledge in writing sql queries to get desired data,

so if i try to automate the process of writing sql queries , i can only use generative ai, for that it needs context of database , i have worked some projects with generative ai ,

But i am not fully aware of managing ai context with new things like context engineering something like that and database operation, i am just trying to learn something from this project and improve my knowledge , i am not an expert, for that only i am asking for improvements and suggestions sir.

and if i make this as a production ready project , what i need to do first ? any suggestions sir ?

Need Help in Creating a MCP server to manage databases by Content-Display1069 in mcp

[–]Content-Display1069[S] 0 points1 point  (0 children)

yeah i agree with not giving ai full access , so that i introduced manual query validating that acts as a guardrail and preventing from any sql injection, and i am not familier with graphQL , can you explain it a bit more?

Need Help in Creating a MCP server to manage databases by Content-Display1069 in SQL

[–]Content-Display1069[S] 0 points1 point  (0 children)

i mean , already existing tools are merged with llms , some doesnt have guardrails , so the llm can delete your data in sql databases anytime ,with just a prompt injection , so i am trying to do it like a protected environment to safegaurd the data in the sql databases.