> For the complete documentation index, see [llms.txt](https://docs.jetadmin.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases.md). # SQL Databases Connect your PostgreSQL, MySQL, SQL Server and MariaDB databases to Jet apps. ## 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:
### SQL databases * PostgreSQL * MySQL * Microsoft SQL * MariaDB * SQLite * Oracle * AlloyDB ### Other data sources * [Supabase](/user-guide/data-sources/databases/supabase.md) * [Airtable](/user-guide/data-sources/databases/airtable.md) * [Google Sheets](/classic-app-builder/videos/connecting-data-sources/google-sheet.md) * [Firebase](/user-guide/data-sources/databases/firebase-firestore/firestore.md) * [Xano](/user-guide/data-sources/databases/xano.md) * BigQuery * [Snowflake](/user-guide/data-sources/databases/snowflake.md) * [SmartSuite](/user-guide/data-sources/business-apps/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/data-sources/databases/sql-databases/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/cloud-jet-bridge-and-on-premises/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/data-sources/databases/sql-databases/docker-installation.md) or [Python](/user-guide/data-sources/databases/sql-databases/python-app-installation.md) 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="/pages/-M9ZMb8PM6Sol07rlSo2" %} [Instant Installation](/user-guide/data-sources/databases/sql-databases/instant-cloud.md) {% endcontent-ref %} {% content-ref url="/pages/-M9ZMgwDq3EdQCREfYBL" %} [Docker Installation](/user-guide/data-sources/databases/sql-databases/docker-installation.md) {% endcontent-ref %} {% content-ref url="/pages/-M9ZMwmnUeXrtgWAfsxc" %} [Python app Installation](/user-guide/data-sources/databases/sql-databases/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/cloud-jet-bridge-and-on-premises/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: ![](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](/user-guide/sql-queries-and-api-requests/make-a-sql-query.md) to your database to select the data and use it as virtual tables: {% @arcade/embed url="" flowId="Fg2gqwiVIpsgGl7YNdlq" %} {% content-ref url="/pages/-MACAp62Ew2HNnkoMkrb" %} [Making SQL queries](/user-guide/sql-queries-and-api-requests/make-a-sql-query.md) {% endcontent-ref %} --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. 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.