<p>Assuming you're running Craft CMS 3, the <a href="https://github.com/nystudio107/craft-connect" rel="nofollow noreferrer">Connect plugin</a> will let you connect to MSSQL databases (local or remote)</p>

<p>You'll just need to do:</p>

<pre><code>composer require yiisoft/yii2-mssql
</code></pre>

<p>...on your Craft CMS project. To be clear, this doesn't add support for MSSQL to Craft itself, it just lets you query MSSQL databases in your Twig templates.</p>

CC BY-SA 4.0
2018-08-15T19:45:23.950Z
2018-08-15T19:45:23.950Z
andrew.welch
<p>Craft 3 supports <a href="https://docs.craftcms.com/v3/requirements.html#server-requirements" rel="nofollow noreferrer">MySQL 5.5+ and PostgreSQL 9.5+</a>.</p>

<p>Craft 2 only supports <a href="https://docs.craftcms.com/v2/requirements.html" rel="nofollow noreferrer">MySQL 5.1+</a>.</p>

<p>Yii (the framework Craft runs on) uses <a href="https://secure.php.net/manual/en/book.pdo.php" rel="nofollow noreferrer">PDO</a> for its database abstraction layer, which supports <a href="https://secure.php.net/manual/en/pdo.drivers.php" rel="nofollow noreferrer">many databases</a>, so technically it wouldn't be much work but it's more of a matter of the demand for it and "are we ready to support other databases".</p>

<p>Logically MSSQL would probably be next on the list, but there's not timeline/ETA for it.</p>

CC BY-SA 4.0
2016-03-11T00:28:07.813Z
2018-08-15T19:45:54.193Z
2018-08-15T19:45:54.193Z
Brad Bell
<p>Is there a MSSQL support for Craft CMS?
Or any plugin that can help to connect to a MSSQL database?</p>

<p>Thank you!</p>

<database>
MSSQL Support for Craft?
# MSSQL Support for Craft?

(Asked by: username_0 on 2016-03-11)

Is there a MSSQL support for Craft CMS?
Or any plugin that can help to connect to a MSSQL database?

Thank you!

**Tags:** database


---

## 2 answers

### Answer by username_1 on 2018-08-15. Score: 3

Assuming you're running Craft CMS 3, the Connect plugin will let you connect to MSSQL databases (local or remote)
You'll just need to do:
composer require yiisoft/yii2-mssql

...on your Craft CMS project. To be clear, this doesn't add support for MSSQL to Craft itself, it just lets you query MSSQL databases in your Twig templates.


---

### Answer by username_2 on 2016-03-11. Score: 2

Craft 3 supports [MySQL 5.5+ and PostgreSQL 9.5+](https://docs.craftcms.com/v3/requirements.html#server-requirements).

Craft 2 only supports [MySQL 5.1+](https://docs.craftcms.com/v2/requirements.html).

Yii (the framework Craft runs on) uses [PDO](https://secure.php.net/manual/en/book.pdo.php) for its database abstraction layer, which supports [many databases](https://secure.php.net/manual/en/pdo.drivers.php), so technically it wouldn't be much work but it's more of a matter of the demand for it and "are we ready to support other databases".

Logically MSSQL would probably be next on the list, but there's not timeline/ETA for it.


---

