> 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.md). # Data & Integrations - [Choose where your data lives](https://docs.jetadmin.io/user-guide/overview.md) - [Jet Databases](https://docs.jetadmin.io/user-guide/jet-databases.md): Create a Jet Tables database, choose a template, import a file, and manage your data. - [Create a table](https://docs.jetadmin.io/user-guide/jet-databases/create-a-table.md) - [Import and export data](https://docs.jetadmin.io/user-guide/jet-databases/import-and-export-data.md) - [Field types and primary keys](https://docs.jetadmin.io/user-guide/jet-databases/field-types-and-primary-keys.md) - [Synced tables](https://docs.jetadmin.io/user-guide/synced-tables.md): Bring a table from another database and keep it up to date automatically. One source of truth, used in as many Jet Databases as you need. - [Create a sync connection](https://docs.jetadmin.io/user-guide/synced-tables/create-a-sync-connection.md): Connect a supported source using Sync and verify its records. - [Sync schema changes](https://docs.jetadmin.io/user-guide/synced-tables/sync-schema-changes.md): Refresh a resource's schema after adding or changing tables and fields. - [Refresh data and manage sync](https://docs.jetadmin.io/user-guide/synced-tables/refresh-data-and-manage-sync.md): Refresh record values, inspect sync status, and review sync events. - [Join data from multiple sources](https://docs.jetadmin.io/user-guide/synced-tables/join-data-from-multiple-sources.md): Join synced Orders and Customers data in a read-only Virtual Collection. - [Troubleshoot syncing](https://docs.jetadmin.io/user-guide/synced-tables/troubleshoot-syncing.md) - [Data Sources](https://docs.jetadmin.io/user-guide/data-sources.md): Connect databases, spreadsheets, APIs, business apps, and storage to Jet Admin. - [Connect your first data source](https://docs.jetadmin.io/user-guide/data-sources/connect-your-first-data-source.md) - [Databases](https://docs.jetadmin.io/user-guide/data-sources/databases.md) - [SQL Databases](https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases.md): Connect your PostgreSQL, MySQL, SQL Server and MariaDB databases to Jet apps. - [Instant Installation](https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases/instant-cloud.md): Step-by-step guide to Cloud Installation. - [Docker Installation](https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases/docker-installation.md): Step-by-step guide to installation with Docker. - [Python app Installation](https://docs.jetadmin.io/user-guide/data-sources/databases/sql-databases/python-app-installation.md): Step-by-step guide to installation with Python. - [Firebase / Firestore](https://docs.jetadmin.io/user-guide/data-sources/databases/firebase-firestore.md): How to build business apps on top of Firebase data - [Syncing Firebase Data Using Functions](https://docs.jetadmin.io/user-guide/data-sources/databases/firebase-firestore/syncing-firebase-data-using-functions.md): This is a more efficient data syncing method with Firebase. This replaces the outdated snapshot-based approach, eliminating the need to update entire collections for small changes. - [Firestore](https://docs.jetadmin.io/user-guide/data-sources/databases/firebase-firestore/firestore.md): In this section you will learn how to use Firestore - [Realtime DB](https://docs.jetadmin.io/user-guide/data-sources/databases/firebase-firestore/realtime-database.md): In this section you will learn how to use Realtime DB - [MongoDB](https://docs.jetadmin.io/user-guide/data-sources/databases/mongodb.md): MongoDB is a cross-platform document-oriented database platform. Classified as a NoSQL database product, MongoDB uses JSON-like format to store documents with optional schemas. - [Airtable](https://docs.jetadmin.io/user-guide/data-sources/databases/airtable.md) - [Google Sheets](https://docs.jetadmin.io/user-guide/data-sources/databases/google-sheets.md) - [Amazon Athena (AWS Athena)](https://docs.jetadmin.io/user-guide/data-sources/databases/amazon-athena-aws-athena.md): Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. - [Databricks](https://docs.jetadmin.io/user-guide/data-sources/databases/databricks.md): This guide will help you connect your Databricks database to Jet Admin seamlessly. - [CockroachDB](https://docs.jetadmin.io/user-guide/data-sources/databases/cockroachdb.md): CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. - [ClickHouse](https://docs.jetadmin.io/user-guide/data-sources/databases/clickhouse.md): This guide explains how to connect your ClickHouse database to Jet Admin in a few simple steps. - [Supabase](https://docs.jetadmin.io/user-guide/data-sources/databases/supabase.md): This guide explains how to quickly connect Supabase back-end to a Jet Admin front-end. - [Xano](https://docs.jetadmin.io/user-guide/data-sources/databases/xano.md): This guide explains how to quickly connect Xano back-end to a Jet Admin front-end. - [Django](https://docs.jetadmin.io/user-guide/data-sources/databases/django-framework-package.md): In this section you will learn how to connect Django to Jet Admin - [MySQL](https://docs.jetadmin.io/user-guide/data-sources/databases/mysql.md): Connecting MySQL to Jet Admin - [MariaDB](https://docs.jetadmin.io/user-guide/data-sources/databases/mariadb.md) - [Snowflake](https://docs.jetadmin.io/user-guide/data-sources/databases/snowflake.md) - [APIs](https://docs.jetadmin.io/user-guide/data-sources/apis.md) - [Rest API](https://docs.jetadmin.io/user-guide/data-sources/apis/rest-api.md): Connect Jet Admin to any REST API. - [Basic Authentication](https://docs.jetadmin.io/user-guide/data-sources/apis/rest-api/basic-authentication.md): How to connect to an API with Basic Authentication - [Bearer Token](https://docs.jetadmin.io/user-guide/data-sources/apis/rest-api/bearer-token.md): How to connect to an API with Bearer Token Authentication - [OAuth 2.0](https://docs.jetadmin.io/user-guide/data-sources/apis/rest-api/oauth-2.0.md): How to connect to an API with OAuth 2.0 Authentication - [Jet Requests Auth](https://docs.jetadmin.io/user-guide/data-sources/apis/rest-api/jet-requests-auth.md) - [GraphQL](https://docs.jetadmin.io/user-guide/data-sources/apis/graphql.md): Connect Jet Admin to any GraphQL API - [Business apps](https://docs.jetadmin.io/user-guide/data-sources/business-apps.md) - [Google Calendar](https://docs.jetadmin.io/user-guide/data-sources/business-apps/google-calendar.md): Connect your Google Calendar account to JetAdmin to view, create, and manage calendar events directly inside your app. - [Gmail](https://docs.jetadmin.io/user-guide/data-sources/business-apps/gmail.md): Connect your Gmail account to JetAdmin to access emails, labels, and threads and perform actions directly on your inbox. - [Google Translator](https://docs.jetadmin.io/user-guide/data-sources/business-apps/google-translator.md): Connect Google Translator to JetAdmin to detect languages, list supported languages, and translate text directly in your app or workflows. - [Google Maps](https://docs.jetadmin.io/user-guide/data-sources/business-apps/google-maps.md): Connect Google Maps to JetAdmin to search places, calculate distances, get directions, and access detailed location data. - [SmartSuite](https://docs.jetadmin.io/user-guide/data-sources/business-apps/smartsuite.md) - [Asana](https://docs.jetadmin.io/user-guide/data-sources/business-apps/asana.md): Connect your Asana workspace to JetAdmin to access your data and automate task-related operations - [Zoom](https://docs.jetadmin.io/user-guide/data-sources/business-apps/zoom.md): Connect your Zoom account to Jet Admin to access your data and automate meeting-related operations. - [Intercom](https://docs.jetadmin.io/user-guide/data-sources/business-apps/intercom.md): Sync your contacts data (users and leads) from Intercom into your Jet app. - [Zendesk](https://docs.jetadmin.io/user-guide/data-sources/business-apps/zendesk.md): Sync your tickets and customer data from Zendesk into your Jet app - [Webflow](https://docs.jetadmin.io/user-guide/data-sources/business-apps/webflow.md): This guide explains how to quickly connect Webflow CMS back-end to a Jet Admin front-end. - [SendGrid](https://docs.jetadmin.io/user-guide/data-sources/business-apps/sendgrid.md): Send transactional emails to your users from a Jet app - [Twilio](https://docs.jetadmin.io/user-guide/data-sources/business-apps/twilio.md): Send SMS to your users from a Jet app - [Mixpanel](https://docs.jetadmin.io/user-guide/data-sources/business-apps/mixpanel.md): Connecting Mixpanel to Jet Admin - [OpenAI and Jet Admin](https://docs.jetadmin.io/user-guide/data-sources/business-apps/openai-and-jet-admin.md): Leverage artificial intelligence to generate prompt-based text and images. - [Apify](https://docs.jetadmin.io/user-guide/data-sources/business-apps/apify.md): Learn how to connect Apify to JetAdmin to run Actors, retrieve web data, and use Apify tools in AI Agents and workflows. - [Ahrefs](https://docs.jetadmin.io/user-guide/data-sources/business-apps/ahrefs.md): Learn how to connect Ahrefs to JetAdmin to access SEO metrics, backlink data, keyword research, site audits, and search performance insights inside your AI Agents and workflows. - [Apollo](https://docs.jetadmin.io/user-guide/data-sources/business-apps/apollo.md): Learn how to connect Apollo to JetAdmin to search for people and companies, enrich contact data, and use sales intelligence in AI Agents and workflows. - [Brandfetch](https://docs.jetadmin.io/user-guide/data-sources/business-apps/brandfetch.md) - [Confluence](https://docs.jetadmin.io/user-guide/data-sources/business-apps/confluence.md): Learn how to connect Confluence to JetAdmin to access knowledge base content, manage pages, and use documentation in AI Agents and workflows. - [Devin](https://docs.jetadmin.io/user-guide/data-sources/business-apps/devin.md): Learn how to connect Devin to JetAdmin to manage development sessions, automate engineering workflows, and access project knowledge from AI Agents and workflows. - [Exa](https://docs.jetadmin.io/user-guide/data-sources/business-apps/exa.md): Learn how to connect Exa to JetAdmin to perform AI-powered web search, retrieve webpage content, and provide AI Agents with up-to-date information. - [Fellow](https://docs.jetadmin.io/user-guide/data-sources/business-apps/fellow.md): Learn how to connect Fellow to JetAdmin to access meeting recordings, notes, transcripts, and workspace information from AI Agents and workflows. - [Granola](https://docs.jetadmin.io/user-guide/data-sources/business-apps/granola.md): Learn how to connect Granola to JetAdmin to access meeting notes, transcripts, and workspace data from AI Agents and workflows. - [Parallel](https://docs.jetadmin.io/user-guide/data-sources/business-apps/parallel.md): Learn how to connect Parallel to JetAdmin to perform AI-powered web search, retrieve webpage content, and provide AI Agents with high-quality, up-to-date information. - [Reducto](https://docs.jetadmin.io/user-guide/data-sources/business-apps/reducto.md): Learn how to connect Reducto to JetAdmin to parse documents, extract structured data, classify files, and build document-processing workflows powered by AI. - [Slack](https://docs.jetadmin.io/user-guide/data-sources/business-apps/slack-connections.md) - [Connect Slack with an incoming webhook](https://docs.jetadmin.io/user-guide/data-sources/business-apps/slack-connections/incoming-webhook.md): Send data to Slack as a notification from a Jet app - [Connect Slack with OAuth](https://docs.jetadmin.io/user-guide/data-sources/business-apps/slack-connections/oauth.md): Connect Slack to JetAdmin to access channels, users, messages, and automate communication workflows. - [Salesforce](https://docs.jetadmin.io/user-guide/data-sources/business-apps/salesforce.md): Sync your deals and customer data from Salesforce into your Jet app - [Hubspot](https://docs.jetadmin.io/user-guide/data-sources/business-apps/hubspot.md): Sync your deals and customer data from Hubspot into your Jet app - [Stripe](https://docs.jetadmin.io/user-guide/data-sources/business-apps/stripe.md): Sync your subscription and customer data from Stripe into your Jet app - [Zapier](https://docs.jetadmin.io/user-guide/data-sources/business-apps/zapier.md) - [MCP](https://docs.jetadmin.io/user-guide/data-sources/mcp.md): The basics of MCP servers and how they function as bridges in JetAdmin. - [Connect an MCP server](https://docs.jetadmin.io/user-guide/data-sources/mcp/connect-an-mcp-server.md): Step-by-step setup for connecting MCP servers as datasources. - [Test an MCP tool](https://docs.jetadmin.io/user-guide/data-sources/mcp/test-an-mcp-tool.md) - [Use MCP tools in agents and workflows](https://docs.jetadmin.io/user-guide/data-sources/mcp/use-mcp-tools-in-agents-and-workflows.md) - [MCP authentication and server access](https://docs.jetadmin.io/user-guide/data-sources/mcp/authentication-and-server-access.md): Check server reachability, authentication, and tool permissions. - [Using MCP Server Tools in JetAdmin (with Weather MCP via Smithery)](https://docs.jetadmin.io/user-guide/data-sources/mcp/using-mcp-server-tools-in-jetadmin-with-weather-mcp-via-smithery.md): How to connect a Weather MCP server hosted in Smithery to JetAdmin, explore its actions, and use them in components, workflows, or AI agents. - [MCP limitations and troubleshooting](https://docs.jetadmin.io/user-guide/data-sources/mcp/limitations-and-troubleshooting.md): Diagnose connection, authentication, input, and tool-result problems. - [Manage app data](https://docs.jetadmin.io/user-guide/data.md): Find guides for records, fields, relationships, and calculated values. - [Navigate the Data Editor](https://docs.jetadmin.io/user-guide/data/navigate-the-data-editor.md): Open a table, organize fields, inspect cells, and find guides for common data tasks. - [Records](https://docs.jetadmin.io/user-guide/data/records.md) - [Bulk edits and actions](https://docs.jetadmin.io/user-guide/data/records/bulk-edits-and-actions.md): Easily select one or more records and perform quick actions like duplicate, export, or delete, all in one place. - [Fields](https://docs.jetadmin.io/user-guide/data/fields.md) - [Field types](https://docs.jetadmin.io/user-guide/data/fields/field-types.md): Add and manage basic data like text, numbers, and images - [Add and configure fields](https://docs.jetadmin.io/user-guide/data/fields/add-and-configure-fields.md) - [AI fields](https://docs.jetadmin.io/user-guide/data/fields/ai-fields.md): Turn any field into an AI-powered field that can automatically fill data using your instructions and your existing column values. - [Relationships](https://docs.jetadmin.io/user-guide/data/relationships.md) - [Link records across tables](https://docs.jetadmin.io/user-guide/data/relationships/link-records-across-tables.md): Create relationships and link rows together. - [Many-to-many relationships](https://docs.jetadmin.io/user-guide/data/relationships/many-to-many-relationships.md) - [Relations View](https://docs.jetadmin.io/user-guide/data/relationships/relations-view.md): Link tables together to display related data without switching between views - [Filter related records in Classic App Builder](https://docs.jetadmin.io/user-guide/data/relationships/filter-related-records-in-classic-app-builder.md) - [Computed fields](https://docs.jetadmin.io/user-guide/data/computed-fields.md): Choose formulas, lookups, rollups, or JavaScript to derive field values. - [Rollup Column](https://docs.jetadmin.io/user-guide/data/computed-fields/rollup-column.md): Perform calculations on columns or relations like count, average, and sum. - [Lookup Column](https://docs.jetadmin.io/user-guide/data/computed-fields/lookup-column.md): Retrieve values through a relation. - [Formula](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas.md): Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields - [Setting up promotional email](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas/setting-up-promotional-email.md): In this section, we will build an example of how to set up promotional email - [Create Custom fields using Formulas](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas/create-custom-fields-using-formulas.md): In this section, you will learn how to create custom fields using Formulas - [Parse JSON Fields](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas/parse-json-fields.md): Parse JSON to create new columns with the data you want - [Math Column](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas/math-column.md): Perform instant calculations using the data in your project - [List of Functions](https://docs.jetadmin.io/user-guide/data/computed-fields/formulas/list-of-functions.md) - [JavaScript Column](https://docs.jetadmin.io/user-guide/data/computed-fields/javascript-column.md): Create new computed columns with JavaScript - [Calculated values in column](https://docs.jetadmin.io/user-guide/data/computed-fields/calculated-values-in-column.md): Sum, Count, AVG all the values in your column - [Customers and Orders sample data](https://docs.jetadmin.io/user-guide/data/customers-and-orders-sample-data.md) - [Files & storage](https://docs.jetadmin.io/user-guide/files-and-storage.md) - [Jet Admin Storage](https://docs.jetadmin.io/user-guide/files-and-storage/jet-admin-storage.md) - [Connect external storage](https://docs.jetadmin.io/user-guide/files-and-storage/connect-external-storage.md): Manage files and folders in Jet Admin - [Amazon S3 and S3 compatible storage](https://docs.jetadmin.io/user-guide/files-and-storage/connect-external-storage/amazon-s3.md): Amazon and compatible S3 Cloud Storage - [Google Cloud Storage](https://docs.jetadmin.io/user-guide/files-and-storage/connect-external-storage/google-cloud-storage.md) - [Supabase Storage](https://docs.jetadmin.io/user-guide/files-and-storage/connect-external-storage/supabase-storage.md): Steps to connect Supabase Storage to Jet Admin. By integrating Supabase Storage, you can seamlessly manage and access your files within Jet Admin. - [Firebase Cloud Storage](https://docs.jetadmin.io/user-guide/files-and-storage/connect-external-storage/firebase-cloud-storage.md) - [Upload and manage files](https://docs.jetadmin.io/user-guide/files-and-storage/upload-and-manage-files.md): Access your storages and easily upload files using Jet - [Configure resource storage and app uploads](https://docs.jetadmin.io/user-guide/files-and-storage/configure-resource-storage.md): Easily create new storages or upload files to your storage from the Data Editor. - [SQL queries and API requests](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests.md) - [API Builder](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder.md): The API Builder makes it simple to connect to external APIs, manage authentication, and preview responses. You can configure everything manually or let AI handle most of the setup for you. - [Choose an API response format](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/choose-api-response-format.md): Choose JSON, XML, Text, or Blob to match an endpoint response. - [Sorting data](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/sorting-data.md): In this section you will learn how to sort your data - [Pagination](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/pagination.md): In this section you will learn how to apply pagination - [Page-based pagination](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/pagination/page-based-pagination.md): In this section you will learn how to use page-based pagination - [Offset pagination](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/pagination/offset-pagination.md): In this section you will learn how to use offset pagination - [Cursor based pagination](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/pagination/cursor-based-pagination.md): In this section you will learn how to use cursor-based pagination - [Error Handling](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/error-handling.md): Use the Error Handling section to define custom logic for extracting and displaying meaningful messages from failed HTTP responses. - [Transform API responses](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/api-builder/transform-api-responses.md): Select nested records and transform API response fields. - [Making API requests](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/make-an-http-request.md): An overview of HTTP request - [SQL Query Builder](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/sql-query-builder.md): The SQL Query Builder lets you create, edit, and run queries easily. You can write SQL manually, insert tables and columns, or let AI generate queries and transformations for you. - [Making SQL queries](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/make-a-sql-query.md): An overview of SQL request with PostgreSQL - [Text to SQL](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/text-to-sql.md) - [Use dynamic SQL inputs](https://docs.jetadmin.io/user-guide/sql-queries-and-api-requests/use-dynamic-sql-inputs.md) --- # 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 dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.jetadmin.io/user-guide.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. 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.