# External Sources

Bayeslab supports directly query from external sources using SQL,  without having to sync the data. 

## Database

<figure><img src="https://2463519681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLjXlg9zqMASkILutGQsH%2Fuploads%2FZxtR5O6OVHgah8XDc3Pa%2Fimage.png?alt=media&#x26;token=e7e7fee5-49e1-4874-a4d9-d4c0318cf0db" alt=""><figcaption></figcaption></figure>

When creating table, you can create from Database

<figure><img src="https://2463519681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLjXlg9zqMASkILutGQsH%2Fuploads%2F0iTq5A20wUsfcOq9TYHs%2Fimage.png?alt=media&#x26;token=8e651a2d-1b68-4584-9046-68dfd2c29503" alt=""><figcaption></figcaption></figure>

Currently only MySQL and PostgreSQL are supported, we're going to add more DB types soon.

Be sure to add more description to your columns(data schema), so our AI can better generate results for you.

You can also edit the schema later in Data Preview

<figure><img src="https://2463519681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLjXlg9zqMASkILutGQsH%2Fuploads%2FQhNqfNKBkwlPcR8WdnWG%2Fimage.png?alt=media&#x26;token=f743c141-bc8f-48a2-8279-14921cf01f6f" alt=""><figcaption><p>View and edit data schema</p></figcaption></figure>

{% hint style="warning" %}
Write back to external database is not supported now.
{% endhint %}

## More Integrations

There're more data source that we'll unify under a **single SQL accessible interface**, and enables cross joins.

We're planning to add:

* Amazon Redshift
* Apache Cassandra&#x20;
* Apache Hive&#x20;
* Apache Iceberg
* Clickhouse
* Elasticsearch
* Google BigQuery&#x20;
* Google Sheets&#x20;
* MariaDB&#x20;
* Microsoft SQL Server&#x20;
* MongoDB
* Oracle
* Prometheus
* Redis
* Snowflake&#x20;

{% hint style="warning" %}
Coming soon!
{% endhint %}