halilkkaya/mcp-anlatim
If you are the rightful owner of mcp-anlatim and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The Model Context Protocol (MCP) is a revolutionary protocol that standardizes AI models' access to external data sources, enabling real-time interactions with databases.
The MCP Araç Arama Sistemi is a comprehensive example application that demonstrates the power of the Model Context Protocol (MCP) in a car dealership scenario. By leveraging MCP, AI assistants like Claude and ChatGPT can interact with real-time vehicle databases, providing users with a seamless and efficient car search experience. The system integrates various technologies, including a secure MySQL database, advanced filtering options, and web integration through the Tavily API. It offers multiple interfaces, such as terminal, Streamlit, and web-based platforms, ensuring accessibility and convenience for users. The project emphasizes security with features like parametrized queries to prevent SQL injection and environment variables for API key management. Additionally, it includes performance optimizations like database indexing and caching to enhance response times. This project serves as a practical demonstration of MCP's capabilities, showcasing how AI models can be effectively utilized in real-world applications.
Features
- AI Assistant: Natural language car search with Claude.
- MCP Server: Secure access to MySQL database.
- Advanced Filtering: Over 15 different search criteria.
- Web Integration: Up-to-date vehicle information via Tavily API.
- Multi-Interface: Terminal, Streamlit, and web-based options.
Usages
usage with terminal
# Terminal Uygulaması python app.py
usage with streamlit demo
# Eğitim ve Demo (Önerilen) streamlit run mcpanlatim.py
usage with streamlit web
# Web Uygulaması streamlit run appst.py
usage with mcp server
# MCP Server python dataturkmcp.py
Tools
araba_ara
Main search tool with advanced filtering options.
sql_sorgusu_calistir
Execute custom SQL queries for advanced analysis.
tablolari_listele
List database tables for structure exploration.
tablo_yapisi_goster
Display table schema for column information.
web_arama
Search using Tavily API for current information.