AI SQL queries

Turn your questions into SQL and unlock spatial insights from cloud databases instantly

Felt AI SQL transforms natural language questions into optimized database queries, letting anyone on your team perform complex spatial analysis without writing code. Simply ask questions in plain English and watch as Felt AI generates the SQL, executes it against your cloud database, and visualizes the results on your map.

This feature is only available to customers on the Enterprise plan. To upgrade, contact sales.

Examples

Perform complex spatial analysis

Explore data schema and table attributes

Optimize queries

Create a layer with Felt AI SQL

1. Click on the Library (toolbar) and select your data source under the Sources heading.

2. Select + New SQL query (or select a table and click ... > Write SQL query).

3. The SQL query window will open

   

   1. the left side includes all the tables and views available in your source as well as recent queries the team has run

   2. the right side includes the SQL query editor (top) and the AI prompt area (bottom) where you can provide prompts to Felt AI. Use the Schema and Metadata tabs (bottom) to learn more about the structure of tables in the database.

4. Once Felt AI generates SQL, a preview will run automatically. Use the Results tab (bottom right) to review results from the SQL query in table format.

5. Click Create Layer to add your data to the map.

   1. The dropdown option allows you to set the Live sync Frequency or turn Live syncs off

1. A new layer will be added to your map and you can start styling your results.

Learn more

See SQL queriesto learn about tips and tricks, advanced features, and debugging.

Frequently Asked Questions

What is Felt AI SQL?

Felt AI SQL transforms natural language questions into optimized database queries, allowing anyone on your team to perform complex spatial analysis without writing code. You ask questions in plain English, and Felt AI generates the SQL, executes it against your cloud database, and visualizes the results on your map.

Who can access Felt AI SQL?

This feature is only available to admin and editors on the Enterprise plan. To upgrade, contact sales.

Do I need to know SQL to use this feature?

No, you can ask questions in plain English and Felt AI will generate the SQL code for you. However, you can also write or modify SQL directly if desired.

How do I review my query results?

Use the "Results" tab (bottom right) to review results from the SQL query in table format. A preview runs automatically once Felt AI generates the SQL.

Can I control how often my data syncs?

Yes, when clicking "Create Layer," the dropdown option allows you to set the Live sync Frequency or turn Live syncs off.

How can I learn more about my database structure in Felt?

Use the "Schema" and "Metadata" tabs at the bottom of the interface to learn more about the structure of tables in the database.

What happens after I create a layer?

A new layer will be added to your map and you can start styling your results immediately.

Does Felt AI SQL execute queries automatically?

Yes, once Felt AI generates SQL, a preview will run automatically so you can review the results before creating the layer.

Can I write or modify SQL directly?

Yes, the SQL editor allows you to write or modify SQL queries directly if you prefer not to use the AI prompt feature.

Where can I find more information about SQL queries in Felt?

See the SQL queries documentation to learn more about Felt's SQL query capabilities.