Chat with Lakebase Postgres with AskYourDatabase

Chat with your Lakebase Postgres database without writing SQL

AskYourDatabase is the ChatGPT for SQL databases, enabling you to interact with your SQL databases using natural language. You can use it for data management, business intelligence, schema design & migration, data visualization, and more. To learn more, see AskYourDatabase.

This guide shows how to connect from AskYourDatabase to Lakebase Postgres.

• AskYourDatabase Desktop app. See Download AskYourDatabase.
• A Neon project. See Create a Neon project.

1. Get the Neon URL by navigating to the Neon Console and copying the connection string. The URL will look something like this:

   postgresql://alex:AbC123dEf@ep-cool-darkness-123456.us-east-2.aws.neon.tech/dbname?sslmode=require&channel_binding=require

2. Go to AskYourDatabase and click Connect to your database:

3. Select PostgreSQL as your database type, and paste your connection string:

   

4. A new chat session opens if the connection is successful:

   

Within the chat session, you can start asking your database questions.

For example, suppose you have a user table with a column named dbType that indicates the type of database.

If you want to know what the four most popular databases are and visualize the distribution in a pie chart, you can quickly and easily do so with a natural language question, as shown below:

AskYourDatabase also supports a customer-facing chatbot that can connect to a Lakebase Postgres database. You can embed the chatbot in your existing website, enabling your customers to explore analytics data by asking questions in natural language. To learn more, see Create and Integrate Chatbot, in the AskYourDatabase documentation.