Connecting AI to Your Database

What You Can Do With AI and Databases

Traditional database management requires knowing SQL, understanding table relationships, and using specialized tools. AI removes those barriers. You connect your database, the AI reads your schema to understand your tables and columns, and then you interact with your data using plain English questions.

The practical value is immediate. A business owner who has years of customer and sales data locked in a MySQL database can start asking questions like "which products had the highest return rate last quarter" or "show me customers who ordered more than 3 times but have not ordered in 60 days" without learning SQL or hiring a data analyst.

SQL Databases: MySQL and PostgreSQL

If you already have a MySQL or PostgreSQL database, you connect it to the platform by providing your database host, port, credentials, and database name. The AI reads your schema automatically and begins answering questions within minutes.

Both database types support the full range of AI features: natural language querying, web-based table browsing, inline record editing, pattern detection, and automated report generation. The choice between MySQL and PostgreSQL depends on your existing setup and specific needs. See MySQL vs PostgreSQL: Which Should You Choose for a detailed comparison.

For databases hosted on AWS, the platform can connect directly to RDS instances. See How to Connect a Remote Database on AWS RDS.

NoSQL Key-Value Databases

The platform includes a built-in NoSQL key-value database powered by DynamoDB. This is ideal for new applications, game backends, custom apps, and any use case where you need fast, flexible data storage without designing a relational schema upfront.

Key-value databases trade the complex query capabilities of SQL for extreme speed and simplicity. They work with partition keys and sort keys rather than tables with joins, making them perfect for applications that need to read and write individual records quickly. See What Is a NoSQL Database and How to Set Up a Key-Value Database.

AI-Powered Database Features

The AI layer adds capabilities that go beyond basic data access:

• Natural language queries: Ask questions about your data in plain English. The AI translates to SQL, runs the query, and returns results. See Query With Plain English.
• Schema understanding: The AI automatically learns your table structure, column types, and relationships. See How the AI Understands Your Schema.
• Pattern detection: AI analyzes your data for trends, anomalies, and correlations you might not find manually. See Find Patterns in Your Database.
• Data cleaning: AI identifies and fixes duplicates, inconsistencies, and formatting issues. See Clean and Fix Database Records.
• Automated reports: Schedule AI to query your database and generate written reports on a recurring basis. See Automate Database Reports.

Guides and Tutorials

Getting Started

AI SQL Features

Use Cases

Technical