Live Chat

We'll need to share your messages (and your email address if you're logged in) with our live chat provider, Drift. Here's their privacy policy.

If you don't want to do this, you can email us instead at contact@anvil.works.

Using MS SQL Server from Anvil apps

Are you new here?

Anvil is a tool for building full-stack web apps with nothing but Python and a drag-and-drop designer. Learn more on our website, or sign up and try it yourself -- it's free!

It’s easy to access an SQL Server database from an Anvil app!

Because an Anvil app has a full Python instance in the back-end, you can use an SQL Server driver such as pymssql to control your MS SQL database, as you would in any Python environment.

Do I need SQL Server to use Anvil?

No, you don’t!

Anvil also has a built-in database system called Data Tables (here’s a tutorial). Data Tables have visual designer for composing a schema, and Python methods for searching. Data Tables is backed by PostgreSQL, which provides robustness and scalability. On the business plan, Data Tables can be accessed in SQL, but most users prefer to use the Python API.