Enable AI assistants to query and optimize PostgreSQL databases using natural language via a secure MCP server deployed on AWS ECS Fargate with credential isolation.
A production-grade Model Context Protocol (MCP) server for PostgreSQL that enables AI assistants to perform natural language SQL generation, schema inspection, query optimization, and database health diagnostics without exposing raw database credentials to client applications. Supports Admin and Tenant operating modes deployed on AWS ECS Fargate.
The Tech 42 PostgresSQL Text-to-SQL MCP Server lets AI assistants query, analyze, and optimize PostgreSQL databases using natural language, no SQL expertise required. Whether you're running AI agents with AWS Bedrock, building agentic workflows, or giving teams a safe database interface, this Model Context Protocol (MCP) server delivers schema discovery, text-to-SQL generation, query optimization, and database health monitoring out of the box.
Built for AWS, the server deploys as a container on Amazon ECS Fargate behind an Application Load Balancer, with credentials managed through AWS Secrets Manager. It connects to Amazon RDS and other PostgreSQL instances via VPC Peering, keeping all database traffic private. Two access modes: Admin for development and DBA workflows, and Tenant Mode for multi-tenant apps with row-level security (RLS); make it flexible for both internal tools and customer-facing applications.
Key capabilities include: natural language SQL, slow query analysis, index recommendations, workload analysis, hypothetical index planning with HypoPG, schema inspection, and comprehensive database health checks. Compatible with Claude, AWS Bedrock Agents, and any MCP-enabled AI agent framework.
Highlights
AI-powered natural language SQL generation converts plain English into optimized PostgreSQL queries, eliminating the need for SQL expertise. Schema discovery, slow query analysis, index recommendations, and hypothetical index planning with HypoPG give teams comprehensive database intelligence through a single MCP interface - compatible with any MCP-enabled AI framework.
Flexible access modes: Unrestricted for dev/DBA workflows, Restricted for read-only production diagnostics, and Tenant Mode for multi-tenant apps with row-level security.
Deploys as a fully managed container on Amazon ECS Fargate behind an Application Load Balancer with no servers to maintain.
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Try this product free for 30 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
This product uses a single usage-based dimension: Container Hours. You pay for each hour the container runs, billed by actual usage. There are no tiers or fixed commitments. Your cost scales directly with how long the server stays active. The longer you run it, the more hours accrue. This server lets AI agents query a PostgreSQL database in plain English and run read-only optimization checks. Because billing is hourly, your total depends on your own runtime rather than a set plan size.
Top-of-mind questions for buyers
What counts as one Container Hour for billing?
A Container Hour measures each hour the MCP server container runs on AWS. The meter tracks running time only. If the container runs for part of an hour, billing follows the partial runtime by that unit. Multiple running containers each accrue their own hours at the same time.
Am I charged when the container is stopped or idle?
Charges apply only while the container runs. A fully stopped container does not accrue Container Hours. Underlying AWS infrastructure, such as storage, may still incur separate AWS fees, but the software meter counts running time alone. Your cost tracks the hours the server stays active.
Does query volume or database size affect my Container Hours?
No. Billing depends on how long the container runs, not on how many queries you send or how large your PostgreSQL database is. Running many plain-English queries in one hour costs the same as running few. Only elapsed runtime drives the Container Hours meter.
sqlagent.tech42demo.com
Helpful?
Vendor refund policy
30-free trial offered. Consumption is usage based. To stop charges, cancel the subscription.
Request a private offer to receive a custom quote.
How can we make this page better?
Tell us how we can improve this page, or report an issue with this product.
Give us feedbackReport a problem with this product or seller
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA).
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Containers are lightweight, portable execution environments that wrap server application software in a filesystem that includes everything it needs to run. Container applications run on supported container runtimes and orchestration services, such as Amazon Elastic Container Service (Amazon ECS) or Amazon Elastic Kubernetes Service (Amazon EKS). Both eliminate the need for you to install and operate your own container orchestration software by managing and scheduling containers on a scalable cluster of virtual machines.
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
VeloDB Cloud: The Real-Time Analytical Database Built for Analytics and AI.
VeloDB Cloud is the fully managed, cloud-native real-time analytical database powered by Apache Doris - the fastest open-source OLAP engine trusted by 5,000+ enterprises worldwide. Deliver sub-second analytics, hybrid search, and AI-ready data infrastructure from a single unified platform.
VeloDB Cloud: The Real-Time Analytical Database Built for Analytics and AI. VeloDB Cloud is the fully managed, cloud-native real-time analytical database powered by Apache Doris - the fastest open-source OLAP engine trusted by 5,000+ enterprises worldwide. Deliver sub-second analytics, hybrid search, and AI-ready data infrastructure from a single unified platform.
Note: The public offer supports only Pay-As-You-Go (PAYG) subscriptions. If you prefer a discounted contract, please request a private offer.
This product has charges associated with it for seller support. PostgreSQL on Ubuntu 24.04 LTS offers a powerful, open-source relational database management system, optimized for high performance, reliability, and scalability. Leveraging the stability of Ubuntu 24.04 LTS, this AMI simplifies the deployment of PostgreSQL in the EC2 cloud, enabling seamless integration with your applications. Benefit from advanced features such as JSON support, full-text search, and robust transaction processing capabilities. Ideal for developers and businesses needing a reliable database environment for web applications, analytics, and data-intensive workloads, this AMI allows for quick launch with pre-configured settings to expedite your project timelines. Utilize automated backups and scaling options to ensure your database grows with your business without compromising performance or security.
This product has charges associated with it for seller support. PostgreSQL on CentOS 10 is a robust, open-source relational database management system optimized for performance and reliability in cloud environments. It leverages the stability of CentOS 10, providing a secure and efficient platform for deploying scalable applications. With features such as advanced data types, support for concurrent connections, and powerful indexing, this AMI is perfect for handling complex queries and large datasets. It's ideal for developers and businesses looking to manage data-intensive applications, from web services to analytics. Streamline your database management and enhance your application's performance with this ready-to-run PostgreSQL instance, all while enjoying the benefits of seamless integration within the AWS ecosystem.
This product has charges associated with it for seller support. PostgreSQL on Amazon Linux 2023 offers a highly scalable, open-source relational database solution optimized for the AWS cloud environment. Deploying this AMI provides a secure, well-configured PostgreSQL installation, allowing you to focus on building applications without worrying about the underlying infrastructure. Leverage seamless integration with other AWS services, such as S3 for storage and Lambda for serverless computing, to enhance your application capabilities. The latest Amazon Linux 2023 enhancements ensure robust performance and security, while automatic updates keep your system running smoothly. Ideal for developers and enterprises looking to host applications ranging from data warehousing to web applications, this AMI simplifies PostgreSQL management and accelerates your time to market, making it a strategic choice for cloud-based database solutions.
This product has charges associated with it for seller support and pre-configured stack (Adminer) in it. Intuz PostgreSQL is a pre-configured, ready to run image for running PostgreSQL on Amazon EC2 and has Apache2, PHP, Adminer, PostgreSQL, and Scripts which make it easy for you to use PostgreSQL.
This product has charges associated with it, which includes support from Cloud Infrastructure Services. PostgreSQL Server and pgAdmin Web GUI on Ubuntu Server. Open-source relational database system on AWS.
Be the first to review this product. We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.