Template thumbnail

Containerised MCP Chat Buddy

Product information

Version 1.0 (Updated )

Containerised environment for quickstart & minimal setup. Completely local MCP setup with Ollama. Chat to the ai with capabilities to search your PSQL Database (All in Elixir). Instructions in README.md

Why Choose This Template?

Save 50+ hours of development
Production-ready code
Modern best practices
Comprehensive documentation
✅ Instant Access
🔒 Secure Payment
💝 Lifetime License

Highlights - ai_tool Kit

  • Landing Page
  • Devcontainer Setup
  • Ollama
  • MCP
  • MCP Database access

What's Included

Ai model flexibility

Multi-Model AI Support - Not locked into one AI provider. Built-in support for any Ollama model (qwen2.5, llama3.1, mistral, etc.) with easy configuration. Switch models based on your needs - speed, accuracy, or cost.

🤖 OpenAI Ready ⚡ Real-time

Conversational responses

Human-Like Result Interpretation - Raw database results get transformed into friendly, conversational responses. The AI explains what it found in natural language, making complex data accessible to non-technical users.

✅ Production Ready

Database discovery

Automatic Schema Intelligence - AI automatically discovers your database structure, table relationships, and column types. Add new tables and the AI immediately understands them without manual configuration.

✅ Production Ready

Devcontainer ready

Zero-Config Development Environment - Start coding in seconds, not hours. Pre-configured DevContainer with Elixir 1.18, PostgreSQL 17, Ollama AI, and all development tools. One command gets you a complete, isolated development environment with GPU support.

✅ Production Ready

Extensible architecture

Infinitely Customizable Foundation - Clean, modular design makes adding new AI tools, database tables, or UI components effortless. Well-documented code with clear separation of concerns lets you adapt this foundation to any domain.

✅ Production Ready

Gpu acceleration

High-Performance AI Processing - Built-in GPU support in the DevContainer means lightning-fast AI responses. Optimized for modern hardware to deliver the snappy experience users expect from AI applications.

✅ Production Ready

Intelligent retry system

Bulletproof Error Recovery & Auto-Correction - Never worry about AI making mistakes again. Our advanced retry system automatically detects prohibited operations, fixes syntax errors, and tries again with safer queries. It's like having an expert DBA watching over your AI.

✅ Production Ready

MCP integration

Revolutionary Model Context Protocol (MCP) Implementation - Be among the first to master the cutting-edge MCP standard that's reshaping how AI agents interact with data. This complete server/client implementation shows you exactly how to build secure, scalable AI tools that can safely access your databases.

✅ Production Ready

Natural language sql

Chat with Your Database Like a Human - Transform complex SQL queries into simple conversations. Ask 'How many Arabian horses do I have?' and watch as AI converts your natural language into perfect SQL, executes it safely, and explains the results in plain English.

✅ Production Ready

Production ready

Battle-Tested Production Code - This isn't a toy demo. Every component follows Phoenix best practices with proper error handling, logging, monitoring hooks, and deployment considerations. Copy-paste into your production app with confidence.

✅ Production Ready

Sample database

Sample Dataset Included - Start experimenting immediately with 20 carefully crafted horse records spanning multiple breeds, ages, colors, and sizes. Perfect for testing queries and understanding data relationships without building your own dataset.

✅ Production Ready

Security first

Enterprise-Grade Security Built-In - Sleep peacefully knowing your AI can't accidentally damage your data. Read-only database access, IP restrictions, prohibited operation blocking, and comprehensive audit logging. Security isn't an afterthought - it's the foundation.

✅ Production Ready

Structured output

JSON Schema-Enforced AI Responses - Stop parsing unreliable AI text responses. Our implementation uses Ollama's structured output with strict JSON schemas, ensuring consistent, parseable responses every time. No more regex parsing or fragile text processing.

✅ Production Ready

Typed structs

Type-Safe Configuration Management - Modern Elixir development with TypedStruct for bulletproof parameter handling. Compile-time type checking, comprehensive documentation, and IDE autocomplete make your code maintainable and error-free.

✅ Production Ready

Built with Modern Technology Stack

Leveraging the best tools and services for rapid development

Phoenix Framework
Elixir
Tailwind CSS
PostgreSQL
Stripe
EmailJS
Oban Background Jobs

Screenshots

A sneak peak into what it'll look like.

404
404
404

License

For personal and professional use. You cannot resell or redistribute this template in it's original or modified state.

Frequently Asked Questions

How do i recieve the template when i purchase it?

It will be added to your account for download at any time.

Can i use the templates for my own SAAS?

Yes. These templates are designed for that purpose, you just cant re-distribute the template itself.