# 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](/files/-MjZ5pHRwy0pJsstY7JP)

### 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](/user-guide/integrations/supabase.md)
* [Airtable](/user-guide/integrations/airtable.md)
* [Google Sheets](/videos/connecting-data-sources/google-sheet.md)
* [Firebase](/user-guide/integrations/firebase-firestore/firestore.md)
* [Xano](/user-guide/integrations/xano.md)
* BigQuery
* [Snowflake](/user-guide/integrations/snowflake.md)
* [SmartSuite](/user-guide/integrations/smartsuite.md)
* 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](/user-guide/integrations/database-resources/instant-cloud.md) 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](/jet-bridge-deployment/jet-admin.md) 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](/user-guide/integrations/database-resources/docker-installation.md) or [Python](/user-guide/integrations/database-resources/python-app-installation.md) Installation to deploy Jet Bridge.

![](/files/-MjZ5vWr0KHetBPGnKg0)

{% content-ref url="/pages/-M9ZMb8PM6Sol07rlSo2" %}
[Instant Installation](/user-guide/integrations/database-resources/instant-cloud.md)
{% endcontent-ref %}

{% content-ref url="/pages/-M9ZMgwDq3EdQCREfYBL" %}
[Docker Installation](/user-guide/integrations/database-resources/docker-installation.md)
{% endcontent-ref %}

{% content-ref url="/pages/-M9ZMwmnUeXrtgWAfsxc" %}
[Python app Installation](/user-guide/integrations/database-resources/python-app-installation.md)
{% endcontent-ref %}

### Deploy database to Heroku

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

{% content-ref url="/pages/-M9ZXvG7No61WoEWcPiD" %}
[⛺️ Database Heroku deployment](/jet-bridge-deployment/database-heroku-deployment.md)
{% 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:

![](/files/NHxLpIKL40czm5A81z4e)

### Make an SQL queries

Using Database integration you can make simple or [SQL queries](/user-guide/data/make-a-sql-query.md) 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="/pages/-MACAp62Ew2HNnkoMkrb" %}
[Making SQL queries](/user-guide/data/make-a-sql-query.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.jetadmin.io/user-guide/integrations/database-resources.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.