Overview
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-native PostgreSQL interface with natural language SQL generation, schema discovery, index tuning, and database health diagnostics via MCP tools.
- 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.
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
Dimension | Description | Cost/unit/hour |
|---|---|---|
Hours | Container Hours | $3.00 |
Vendor refund policy
Need legal review.
Custom pricing options
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
New delivery option 1
- Amazon ECS
Container image
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.
Version release notes
Initial release
Additional details
Usage instructions
Refer following product guide: https://tech42-text2sql-mcp-deployment-asset.s3.us-east-1.amazonaws.com/tech42-text2sql-mcp-deployment-guide.docx.pdf
Resources
Vendor resources
Support
Vendor support
Contact us at support@tech42consulting.com or visit our website at tech42consulting.com
AWS infrastructure support
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.