---
title: "Introduction"
slug: "introduction-to-sql"
description: "An overview of how SQL datasources work, which database systems are supported, and how to use query results in your content."
updated: 2026-08-26T13:38:36Z
published: 2026-08-26T13:38:36Z
canonical: "help.mail-and-deploy.com/introduction-to-sql"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.mail-and-deploy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction to SQL

### General

SQL datasources can be used to directly connect SQL databases to Mail & Deploy. The following SQL datasources are supported:

- [Microsoft SQL Server Databases](/release36/docs/microsoft-sql-server-databases)
- [MySQL Databases](/release36/docs/mysql-databases)
- [Oracle Databases](/release36/docs/oracle-databases)

### Considerations

When rebuilding the cache of an SQL datasource, Mail & Deploy will collect all tables, views, and their columns. When filtering the data model (i.e. using a [Filter Datasource Field Action](/release36/docs/filter-datasource-field)) the filter will only be applied to the view or table to which to the filtered field belongs. Mail & Deploy will not automatically filter related (i.e. by foreign keys) tables or views.

Whitelist IP addresses and Ports

Please contact us to get the IP address that should be whitelisted if this is required. Please let us know if you need us to open an outgoing port.