Streamlit / SQL Server

[AZZAZ_Abdelkarim]

Hi Everyone ,
I’m just getting started with Streamlit .
I want to now if is it possible to connect with SQL Server and query from a Streamlit Dashboard.
Thank you!!

[AvratanuBiswas]

Hi @AZZAZ_Abdelkarim ,

Welcome to the Streamlit Comunity Forum

Yes, it is possible.
Check out this detailed video tutorial from @Jesse_JCharis

Securing Login Section/Page Against SQL Injections

Probably this will help.

Best
Avra

[AZZAZ_Abdelkarim]

Thank you so much !!

[AvratanuBiswas]

You are welcome !

[randyzwitch]

Welcome to the community @AZZAZ_Abdelkarim!

When you’re ready to deploy on Streamlit Cloud, we now support SQL Server as well:

How to add an ODBC driver to streamlit cloud?

Hi, I have an app that works locally fine, but requires ‘ODBC Driver 17 for SQL Server’ to be installed to retrieve data using pyodbc when deployed. I have tried using a requires.txt file with combinations of the below (as per other posts) but it comes up with a could not be located message (I guess because Linux based). What does everyone else do to get around this? As there must be a way to do this, any help massively appreciated. unixodbc-dev msodbcsql17 mssql-tools [Screenshot 2022-01-…

A connection guide will be added to our docs in the coming weeks.

Best,
Randy

[AZZAZ_Abdelkarim]

Thank you so much @randyzwitch !!