# Database resources

## Connecting database as a resource

We support direct connection to various databases, as well as connections to 3rd party database services.

To connect a database with **Jet Admin**, choose a database from the list of available integrations:

![We support 16 different databases](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LQ08RFAKZvFADEiXKFy%2F-MjZ3LfsU1ZReomd0nUz%2F-MjZ5pHRwy0pJsstY7JP%2Fimage.png?alt=media\&token=2aaf9671-d100-4d7e-b707-2ab7dda09472)

### List of available databases:

* Jet Tables (PostgreSQL hosted in Jet Admin Cloud)
* PostgreSQL
* MySQL
* Microsoft SQL
* MariaDB
* SQLite (Instant Connection unavaliable)
* Oracle
* AlloyDB

### List of avaliable 3rd party databases:

* [Supabase](https://docs.jetadmin.io/user-guide/integrations/supabase)
* [Airtable](https://docs.jetadmin.io/user-guide/integrations/airtable)
* [Google Sheets](https://docs.jetadmin.io/videos/connecting-data-sources/google-sheet)
* [Firebase](https://docs.jetadmin.io/user-guide/integrations/firebase-firestore/firestore)
* [Xano](https://docs.jetadmin.io/user-guide/integrations/xano)
* BigQuery
* [Snowflake](https://docs.jetadmin.io/user-guide/integrations/snowflake)
* [SmartSuite](https://docs.jetadmin.io/user-guide/integrations/smartsuite)
* Microsoft SQL
* Amazon Redshift

After choosing a database, you'll need to choose set up method.

{% hint style="info" %}
Set up methods may vary depending on database you choose.
{% endhint %}

Use [instant cloud](https://docs.jetadmin.io/user-guide/integrations/database-resources/instant-cloud) installation to connect Jet Admin with your public database directly (you won't be able to connect to localhost databases). 

We also provide [Jet Bridge](https://docs.jetadmin.io/jet-bridge-deployment/jet-admin) to manage data in case you want to add an extra layer of security for your sensitive data. It will connect to your database and link **Jet Admin** with your project. It will work even with your application on **localhost**. Use [Docker](https://docs.jetadmin.io/user-guide/integrations/database-resources/docker-installation) or [Python](https://docs.jetadmin.io/user-guide/integrations/database-resources/python-app-installation) Installation to deploy Jet Bridge.

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LQ08RFAKZvFADEiXKFy%2F-MjZ3LfsU1ZReomd0nUz%2F-MjZ5vWr0KHetBPGnKg0%2Fimage.png?alt=media\&token=4d043eab-ba07-4549-af0e-70aaf43de7f0)

{% content-ref url="database-resources/instant-cloud" %}
[instant-cloud](https://docs.jetadmin.io/user-guide/integrations/database-resources/instant-cloud)
{% endcontent-ref %}

{% content-ref url="database-resources/docker-installation" %}
[docker-installation](https://docs.jetadmin.io/user-guide/integrations/database-resources/docker-installation)
{% endcontent-ref %}

{% content-ref url="database-resources/python-app-installation" %}
[python-app-installation](https://docs.jetadmin.io/user-guide/integrations/database-resources/python-app-installation)
{% endcontent-ref %}

### Deploy database to Heroku

An example of database deployment on Heroku and further Instant method integration.

{% content-ref url="../../jet-bridge-deployment/database-heroku-deployment" %}
[database-heroku-deployment](https://docs.jetadmin.io/jet-bridge-deployment/database-heroku-deployment)
{% endcontent-ref %}

### Connect through SSH

You can use SHH to **safely integrate** with databases in Jet Admin, if databases support it. Simply enable the toggle here and paste the credentials:

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2Fo7gTPfSTyTWZcBAhfop7%2Fdxjctyj.png?alt=media\&token=09aae491-91e3-4e06-ae49-e45d23d360fd)

### Make an SQL queries

Using Database integration you can make simple or [SQL queries](https://docs.jetadmin.io/user-guide/data/make-a-sql-query) to your database to select the data and use it as virtual tables:

{% @arcade/embed flowId="Fg2gqwiVIpsgGl7YNdlq" url="<https://app.arcade.software/share/Fg2gqwiVIpsgGl7YNdlq>" %}

{% content-ref url="../data/make-a-sql-query" %}
[make-a-sql-query](https://docs.jetadmin.io/user-guide/data/make-a-sql-query)
{% endcontent-ref %}