Connect to MSSQL database

Is it possible to connect to a database and query from it and visualize the data from it?

I was trying to use pymssql. It works on local, but I got error when I tried to deploy it on cloud.
Traceback (most recent call last):

File “/home/appuser/venv/lib/python3.7/site-packages/streamlit/script_runner.py”, line 354, in _run_script

exec(code, module.__dict__)

File “/app/price/PKprice.py”, line 3, in

import pymssql

ModuleNotFoundError: No module named ‘pymssql’

Hey @doveno9,

First, welcome to the Streamlit Community!!! :partying_face: :star2: :star: :star2: :tada:

Did you add the pymssql package to your requirements.txt file?

Here is a link to our docs for connecting to MySQL database. I think the steps would be very similar for connecting to the MSSQL database:

Differences between MySQL and MSSQL

Happy Streamlit-ing!
Marisa