Use Neon as your dev environment for AWS RDS: accelerate your workflow while reducing costs
Community

How to build AI-powered apps using Postgres and DronaHQ

A guide to building an AI app with DronaHQ

Post image

AI, no-code, and low-code have captured the world’s imagination. Developers now have an easier time adding new features than ever before. These new tools have really made a difference for developers, helping them build bigger systems, and do it all much faster. 

In this article, I want to draw your attention to internal tools. Internal operations that power the lifeblood of your organization, are often running on overly complex systems, or outdated legacy tools, or managed over hard to manage spreadsheets and email threads. While decision-makers see the need for optimized internal tools, often those projects never see the light of the day as more critical projects take priority.

Developers need a fast and reliable way to build digital tools that help them store & manage their data, build frontend on stored databases, and leverage new-age APIs (think OpenAI) without any of the code complexities and all of the powerful capabilities. And these scenarios are precisely where low-code technology is lending a helping hand.

How can AI and low code help you boost operations?

Let’s think as a sales manager who has got tons of leads captured in a single day but all with different intentions. Traditionally, managing lead details involves toggling between databases, CRM systems, and email platforms, resulting in a fragmented workflow. This would require a unified frontend that manages all leads at the same time. 

With low-code, the complexities of traditional coding are minimized, allowing developers to visually design the interface and workflows. Using drag-and-drop elements, developers can seamlessly integrate features like lead capture forms, data tables, and interactive dashboards. The low-code approach accelerates the development process, enabling developers to focus on business logic rather than intricate coding. 

Now adding AI power to it and making the conversation with leads more personalized can help the sales team acquire the lead. Low code tools have started integrating AI APIs into their platform helping developers to quickly connect to AI models and build AI-powered applications smoothly.

To demonstrate it better, let’s consider this example: 

Your growth team needs a tool that allows them to read lead information stored in your database to better manage lead communications and they’d like to send personalized emails to said leads. To make the experience more in line with modern-day practices, they’d also like an AI feature that auto-generates the email subject line and body.

Let’s see how we can use Neon, DronaHQ, and OpenAI APIs to build this solution in under an hour. 

What we will do

Neon does more than just store data. It keeps things organized, safe, and can handle a lot of information as your needs get bigger. Whether you’re working with leads, user info, or complicated transactions, Neon is built to manage everything smoothly.

On the other hand, DronaHQ, a low-code app development platform lets you build the frontend on top of Neon. With 100+ ready UI controls and a ready connector for Neon, you can build dynamic forms, dashboards, portals, and more with drag-and-drop simplicity. Additionally, DronaHQ simplifies the integration of AI into your applications by providing a ready OpenAI connector.

With DronaHQ, developers can manage data, automate tasks, and connect seamlessly with their existing systems. DronaHQ heavy-lift app development & deployment tasks with built-in features like user management, SSO, security, environments, version history, audit logs, and analytics.

The possibilities are endless. In this guide, we will walk you through connecting Neon to DronaHQ and building a lead management frontend on top of data stored in Neon that allows you to send AI-generated personalized emails to every lead. 

What we need to do is:

  1. Set up a database on Neon
  2. Connecting Neon to DronaHQ
  3. Building lead management app on DronaHQ
  4. Adding OpenAI connector and connecting with Gmail

Setting up Neon 

Step 1: Register on Neon and initiate a new project

Go to Neon’s website, make an account, and then create a new project on Neon. This project will act as the behind-the-scenes engine for your DronaHQ app.

Step 2: Get the connection string

Post image

Upon successful project creation in Neon, proceed to the project dashboard. Within this dashboard, locate the essential connection string associated with your database. The connection string helps in establishing the link between Neon and DronaHQ.

Connecting Neon to DronaHQ

Go to DronaHQ studio, log in to your account, or else sign up for an account. 

After successfully signing in/signing up:

Step 1: Adding Neon as a data source in DronaHQ

  1. Search for connectors in DronaHQ studio, and select PostgreSQL
Post image Post image
  1. Enter the connector name.
  1. Now input the connection string.
  1. Click on Test and save.

With the connector configured, you’ll find it listed under the custom database connectors. To retrieve data or perform additional actions, simply click on the “Add query” option once your connection is established.

Step 2: Adding queries to the Neon connector

Post image

Within this interface, you have the flexibility to incorporate both simple and complex queries. On the screen’s right-hand side, you’ll encounter a list of tables sourced from the database. By expanding these tables, you gain visibility into the fields associated with each. For our specific use case, it’s essential to configure two distinct queries:

  1. Insert Data
  2. Retrieve Data

Building lead management app on DronaHQ

Step 1: Designing table UI for a lead management app

  1. Navigate to the “Apps” section in the left menu and initiate the app-building process by clicking on the “+” sign.
  1. Once your app is created, drag the table grid control from the controls section.
Post image
  1. Access its data binding properties, and choose ‘Quick Select’ followed by ‘Connector Library.’
Post image
  1. A new tray will appear at the bottom, providing you with the interface to establish the data binding for your Table Grid. We’ve prepared a set of Data queries, created to fetch our sales lead data directly from the Neon database.
Post image
  1. Next, leverage the options in the right sidebar section to customize the columns in your Table Grid. This allows you to specify the columns you wish to include, hide, or remove from your table grid control.
Post image
  1. Additionally, customize the Table Grid properties to activate features such as search, filter, and sorting. Easily enable CRUD operations and more by simply toggling the corresponding switches.
Post image
  1. Now once the table grid is configured, add a detailed view control to fetch the table grid details into it. In the data-bind section for detailed view control, we have used {{tablegridname.PROPERTIES.SELECTEDROWS}} query. When you click on any row in the table grid, all the specific details of that row will be displayed in detailed view control. 
  1. In the detailed view, we will add a button control named “Contact”. We will add a navigation to the email screen. That contact button will navigate to the email screen. 
Post image

Step 2: Creating an email interface for a leads management app

  1. Now to send AI-generated emails, we will build an email screen that will let you send emails to the selected contact from the table grid. 
  1. To build the email screen, we will select the “Tray” screen option from the screens available and we will use UI controls such as text input, rich text editor, and buttons. 
Post image

Adding OpenAI connector and connecting with Gmail

Now once the email screen is configured, we will connect it with the OpenAI connector to generate emails. 

Step 1: Bind data to controls

  1. For the email UI control, click on the data-bind option and write a query that will take the selected email from the table grid. The query used was {{tablegridname.email}}
Post image
  1. For the subject and email body, we will connect the respective controls with OpenAI to generate the data from AI. 
  1. Go to the screen open action of the email screen. 
Post image
  1. Now in the screen_open action, select server-side action, add the OpenAI connector, select GenerateText action then select environment and continue. 
Post image
  1. Select the model like here we have “text-davinci-003”. Then input the prompt for the email subject line. Click Continue.
  1. Give the action name, then add a variable give it a name, and select “output.choices.text”. Click on finish.
Post image
  1. Now in the success branch, we have added an on-screen action for JS code.  In the JS code add a keyword for openAI connector and give a test value. Here our test value string had extra characters/symbols, so the below JS code removes the extra symbols. 
Post image
  1. Click continue and add a variable, here we have named it “Subject”. Click finish.
Post image
  1. Now the same method repeats for generating the email body. First, select OpenAI connector from action, then select the model and give it a prompt for the email body. Click continue then add a variable with the value “Output.choices.text”
  1. The next step is to add a JS code action in the success branch. Create a variable give it a test value and continue. Then create a variable as we did as “Body”. 
Post image
  1. Now in the email screen, we have used an input control for the subject line and a rich text editor for the email body. 
  1. Now the final step is to set the control value. Select the on-screen action of “Set control value”. 

Select the subject input control and give it the value that comes from the JS code. Here we have named it as the subject so the value would be “JSCODE.subject”.  And same for rich text editor for email bodies. 

Post image
  1. The final action flow will look like this. 
Post image

Step 2: Connecting with Gmail

  1. Now we will add an email action for every user who clicks on the “Send mail” button. 
  1. Click on the button and select actions, then go to server-side action and select Gmail connector. Select the account and then fill in the input details with keywords. 
Post image

Once all these steps are done, you are ready to send AI-generated emails to respective email IDs. 

Watch this video to understand more about adding an OpenAI connector. 

Conclusion

There’s so much you can do with AI, and every AI has an API that you can connect internally and build frontend applications on it. For buyers like CTOs, CIOs, or IT leaders, putting AI capabilities in their apps is a smart move. It helps make better decisions, makes things run smoother, and improves how users experience the apps. With AI, they’re not just solving today’s problems but also making sure their apps stay updated and competitive in the tech world.

Lastly, from setting up connectors to fine-tuning Table Grids, it’s all about making your apps smart and efficient. With Neon’s backbone and DronaHQ’s simplicity, you’re now capable of adding AI power to your data stored in Neon. 

Get started with DronaHQ today!