Cover image for boburumurzokov2

Bobur Umurzokov Verified userVerified user

Developer Advocate

boburumurzokov2

Build and Ship AI Agents Faster for Your Business Tooling with Appsmith and Gibsonai

July 9, 2025
5
· 0

Skip the Backend. Ship the Agent.

What started with Copilot — chatting with your code and converting natural language to SQL has now moved to a new level with AI Agents and their tooling capabilities. Agents can now think, understand your business context, respond to real-time data, and evolve with your workflows. They are becoming active participants in data management. AI agents can now provision infrastructure for databases, design your schema, create the tables, and generate REST APIs. You can save hundreds of hours on development with instant API endpoints based on your schema. Because you do not need to set up Postgres/MySQL, write API routes manually, and manage schema migrations. Your AI Agent can manage all as your senior database engineer.

With Appsmith and GibsonAI, you can build smart AI Agents with zero backend that can fully manage your data stack. This article shows how you go from an idea in your mind to a working backend and connected UI for your new AI Agent. I’ll walk through:

  • Why GibsonAI is the perfect brain for database management and backend automation
  • How Appsmith users can go from one idea to a working backend with a single prompt
  • A real-world example: the Startup Watchlist Agent in action

Let’s go!

Demo of the Startup Watchlist Agent building process.

 

Demo of the Startup Watchlist Agent building process.

What is GibsonAI?

GibsonAI provides you with a set of AI Agents to deploy and manage serverless databases. You can interact with these agents using the GibsonAI App chat or the Model Context Protocol (MCP) server. Think of it as an intelligent engine that combines:

  • Long-term memory for other AI Agents

    GibsonAI remembers your schema, your prompts, and your changes. Your agent always knows what tables exist and how your business is structured.

  • Natural language to SQL

    Write “show me all Series A companies from last month” — and it runs a safe, optimized query for you. Works across multiple relational databases like MySQL or Postgres.

  • Live schema awareness

    Change your schema with a prompt? Your REST APIs update instantly, and your AI Agent is aware of this change. You don’t need to rewire anything.

  • Unstructured → Structured

    Scrape a Crunchbase article, upload a PDF, or process an email — GibsonAI can turn it into clean rows in a relational database.

And that’s just the start. Once you connect GibsonAI to your Appsmith agent, you unlock even more backend magic:

  • Create, update, or evolve database schemas using prompts
  • Run safe multi-database experiments
  • Auto-generate test data, restore from backups, or trigger alerts on critical data changes
  • Add fine-grained permissions and multi-tenant logic
  • Build internal apps without touching SQL or API design

Zero Backend Meets Low-Code UI For Your Next AI Agent

I've been using Appsmith for over 4 years, created several internal tools, and used a low-code dashboard builder for developing my startup too. It has been useful for all aspects of UI, as I am a backend engineer. With the new Appsmith AI Agent platform, it’s become even more powerful, enabling full-stack workflows powered by AI, all within a single development surface. When I combined GibsonAI's backend automation with Appsmith Agents, it opened a new way to build AI-powered tools — without touching infrastructure. GibsonAI lets your agent define schemas, run queries, and expose live APIs from a single prompt. Appsmith turns those APIs into beautiful dashboards, workflows, and forms — instantly. You can connect your UI to tools like Notion for documentation, Slack for real-time alerts, Google Sheets for exporting reports, or a bunch of other useful tools available for agents’ actions and knowledge. As someone building a startup tracker and reporting app, this pairing lets me go from idea to interactive tool in minutes. Just AI that ships.

Use Case: The Startup Watchlist Agent

Let me walk you through a real-world example I built with Appsmith and GibsonAI Agents.

Problem: I wanted to track early-stage startups in our space when competitors raise, launch, get acquired, or grow fast.

Solution: I was looking for a quick solution using an AI Agent. AI Agent needs to discover continuously funding news, product launches, hiring activity, and media signals from targeted startups by scraping public sources and storing structured insights into a relational database, so that I can run queries like "Show companies that increased hiring activity in the past 30 days” at any time.

How The Agent Works

To bring the Startup Watchlist Agent to life, I used Appsmith’s AI Agent platform with GibsonAI as the backend brain. Here’s how the Agent operates:

  1. Scraping

    Agent fetches content from Crunchbase and other sources — new articles, blog posts, press releases using Web Scraper knowledge source in Appsmith Agent.

  2. LLM-Powered Structuring & Interpretation

    LLM (Large Language Model) like GPT-4.1 parses text like "AcmeAI raised $25M on July 5th", converts it into relational data format, and generates SQL queries:

    • company_name: AcmeAI
    • event_type: Funding
    • source: TechCrunch
    • summary: Full paragraph
    • url: Source link
  3. Runs SQL via GibsonAI Query API

    Agent runs SQL queries via GibsonAI’s auto-generated REST endpoint.

If you update the schema (say, you add a new column like location or investors), GibsonAI automatically updates the backend and regenerates the REST API. The Appsmith Agent instantly adapts, without needing to update the query code or UI wiring. This makes the whole system incredibly flexible and upgrade-friendly.

The Startup Watchlist Agent is live now! You can try the Agent out instantly using the Appsmith Google Extension with this embed URL:

With a similar setup, you can build more Agents for other use cases such as:

  • Investment intelligence from news sites
  • Real-estate market monitoring tool
  • Regulatory compliance tracker

How to Build a Startup Watchlist Agent

Create a database schema

You can create a database schema for your idea using the GibsonAI App with just one prompt. Under the hood, GibsonAI spun up a new MySQL database with Data API.

GibsonAI creates database schema for prompts

GibsonAI also provides an auto-generated Data API section with full API documentation. Copy the URL and API Key from there.

GibsonAI provides an auto-generated Data API section

Integrate API into Appsmith Agent

Connect the GibsonAI Data API as an authenticated REST API data source in the Appsmith Agent dashboard.

Connect the GibsonAI Data API

Create a GibsonAI Query API request that accepts SQL and parameters — this lets the agent run any query, from inserts to lookups, dynamically.

Create a GibsonAI Query API request

Write detailed system instructions for the AI Agent, so it understands the database schema first, avoids duplicate inserts.

Write detailed system instructions for the AI Agent

Add the Web Scraper tool to extract Crunchbase articles and funding news directly from the web. With all this wired up, the result is a production-ready agent that can process real-world startup news, structure it intelligently, and keep your database and dashboard in sync.

Add the Web Scraper tool to extract Crunchbase articles

Wrapping Up

With GibsonAI and Appsmith, you can:

  • Go from prompt → database → API → UI for your next Agent
  • Let agents manage schema, data, and logic
  • Build backend workflows with just natural language

We started with the Startup Watchlist Agent, but using the same integration, you can build

  • Sales Opportunity Finder Agent
  • Contract Review & Risk Agent
  • Engineering Productivity Tracker Agent

The backend is no longer a blocker for your agent. With Appsmith + GibsonAI, your agent is your backend. Try the Startup Watchlist Agent. Then imagine your own.