Stored procedure using python script

how to create and execute a stored procedure in single store via a python script

This part of the documentation talks about how to connect with Python.

https://docs.singlestore.com/db/v7.6/en/developer-resources/connect-with-application-development-tools/connect-with-python.html

To create an SP, build it as a string in Python and execute the string (use an “execute” method in one of the Python APIs).

Then to call the stored procedure, “execute” a CALL statement like “call myProc()”.

Also, you may want to use ECHO instead of CALL if your SP returns a value.
https://docs.singlestore.com/db/v7.6/en/developer-resources/connect-with-application-development-tools/connect-with-python.html