Leobit
AI-Powered Database Querying Assistant with MCP
We have developed a PoC for an AI-powered database assistant that allows users without a corresponding technical expertise to query a PostgreSQL database using natural language questions in English. The solution executes queries against the Northwind sample dataset and returns human-readable answers.
Our specialists used Angular and Tailwind CSS to develop the solution’s interface that combines a tabbed database browser with a conversational AI chat panel. A .NET-based back end connects to Claude via the Anthropic SDK. Npgsql handles direct data access for the browsing interface. We used the Model Context Protocol (MCP) integration to grant the AI assistant read-only access to the database via the official MCP PostgreSQL server.
The framework demonstrated in this project can be used for connecting any relational database to an AI assistant for simplified data exploration across various business domains.
POC FEATURES
Discover Case study
Get the complete story behind this solution — from the business reasoning to a detailed project breakdown and an in-depth overview of the solution’s key capabilities.
Related Industries
The tool can be applied in any industry where teams need to extract insights from relational databases. The capabilities for natural language querying remove technical barriers and accelerate data-driven decision-making.
Financial Services
Query transaction databases, account records, and reporting tables with natural language. Achieve greater agility in decision-making by identifying crucial spending patterns, flagging anomalies, and generating ad-hoc reports without the help of a dedicated data engineering team.
Healthcare
Explore patient records, appointment histories, and operational datasets without technical expertise with SQL databases. Get fast insights on patient volumes, treatment distributions, and resource utilization to boost the speed of operational decision-making.
Legal Industry
Quickly and conveniently retrieve information about filings, client records, and document metadata. Paralegals and attorneys can use the tool to quickly surface relevant case data during research or preparation without requesting help from technical specialists.
Education & Research
Manage student records, enrollment data, and research datasets without SQL knowledge and technical expertise. Researchers can also explore datasets conversationally, asking questions about distributions, trends, and correlations.
Manufacturing
Conveniently query production databases to monitor inventory levels, track order fulfillment, and analyze supplier performance. Access real-time data insights fast to ensure timely adjustments to manufacturing operations.
Retail & E-commerce
Seamlessly analyze sales data, customer purchase histories, and product performance. Use database data to identify best-selling products, regional trends, or customer segments. The tool supports data-driven inventory and campaign management without requiring SQL expertise.
