topic Connect Flask App to MSSQL database. in SQL database

Connect Flask App to MSSQL database.

Sekelo77 — Tue, 24 Mar 2026 08:50:30 GMT

Hi,

Can you please assist with some advice or guidiance on how to connect my flask application, to our mssql server/database.

Could be a Youtube videos, or any online study material.

I have successfuly build my application and is working fine with sqlite, but my company uses MSSQL Server which is were I need to connect it to, I do have solid background on executing SQL statements, (T-SQL), but my request right is anyone with usefull guideline or information/walk through on how I connect the flask app to our inhouse db, would appreciate that.

Thank you

Re: Connect Flask App to MSSQL database.

v-achippa — Tue, 24 Mar 2026 13:00:52 GMT

Hi Sekelo77,

Thank you for reaching out to Microsoft Fabric Community.

Based on your requirement, since the application is already working with sqlite, you only need to update the database connection. The recommended approach is to use SqlAlchemy with the pyodbc driver, which works correctly with sql server in production environments. Please follow below steps:

Install pyodbc and ensure the ODBC Driver for sql server is installed
Update your connection string to use mssql+pyodbc
Your existing models and queries can remain the same

You can also execute raw T-Sql queries if needed using SqlAlchemy.

Thanks and regards,

Anjan Kumar Chippa

Re: Connect Flask App to MSSQL database.

Sekelo77 — Tue, 24 Mar 2026 13:12:57 GMT

Thank You.