AnyDB MCP Server
A Model Context Protocol (MCP) server that provides intelligent database operations through natural language processing. This server integrates SQLite databases with Ollama for AI-powered SQL generation and execution.
Features
Core Database Operations
- Natural Language to SQL: Convert plain English instructions into SQL queries using Ollama
- Universal Database Operations: Works with any SQLite table/entity without predefined schemas
- MCP Integration: Seamlessly integrates with Claude Desktop and other MCP-compatible clients
- Async Operations: Built on modern Python async/await for high performance
- Safety First: Separate tools for read and write operations
Vector Database & RAG (NEW!)
- File Embedding: Automatically convert files into vector embeddings for semantic search
- Semantic Search: Find relevant content using natural language queries instead of exact keyword matching
- RAG Support: Enable Claude Desktop to answer questions about uploaded documents with context
- Smart Chunking: Intelligently splits large documents into overlapping chunks for better retrieval
- Persistent Storage: ChromaDB-powered vector database with automatic embedding generation
Available Tools
Database Tools
1. query_entity
Query any table with natural language instructions.
Parameters:
entity_name
(required): Name of the table to queryinstruction
(optional): Natural language query instruction (default: "SELECT all records")
Example: Query users table for active accounts
2. insert_entity
Insert records into any table using natural language descriptions.
Parameters:
entity_name
(required): Name of the tabledata
(required): Data to insert (JSON or natural description)
Example: Insert a new user with email and name
3. update_entity
Update records in any table with conditions.
Parameters:
entity_name
(required): Name of the tableinstruction
(required): Update instructionconditions
(optional): WHERE conditions
Example: Update user status to active where email matches
4. delete_entity
Delete records from any table with optional conditions.
Parameters:
entity_name
(required): Name of the tableconditions
(optional): WHERE conditions for deletion
Example: Delete inactive users older than 30 days
5. create_table
Create new tables with AI-generated schemas.
Parameters:
entity_name
(required): Name of the new tableschema_description
(required): Description of table schema
Example: Create a products table with name, price, and category
6. sql_query
Execute raw SQL SELECT queries directly.
Parameters:
query
(required): SQL query to execute
Example: Direct SQL for complex joins and analytics
7. sql_execute
Execute raw SQL modification queries (INSERT, UPDATE, DELETE, CREATE, etc.).
Parameters:
query
(required): SQL query to execute
Example: Direct SQL for complex data modifications
Vector Database Tools (NEW!)
8. add_file_to_vector_db
Add a file to the vector database for semantic search and RAG (Retrieval Augmented Generation).
Parameters:
filename
(required): Name of the filecontent
(required): Content of the file (text)metadata
(optional): Optional metadata for the file
Example: Add a document about machine learning for later semantic search
9. search_vector_db
Search the vector database for relevant file content using semantic similarity.
Parameters:
query
(required): Search query for semantic similaritymax_results
(optional): Maximum number of results to return (default: 5)
Example: Find documents related to "neural networks and AI"
10. list_vector_files
List all files stored in the vector database.
Parameters: None
Example: View all documents available for search
11. remove_file_from_vector_db
Remove a file from the vector database.
Parameters:
filename
(required): Name of the file to remove
Example: Delete outdated documents from the knowledge base
Installation
Prerequisites
- Python 3.8+
- Ollama running locally
- Claude Desktop (for MCP integration)
Setup
- Clone the repository:
- Install dependencies:
- Start Ollama:
- Run the server:
Claude Desktop Integration
Add this server to Claude Desktop by editing your config file:
Windows: %APPDATA%\Claude\claude_desktop_config.json
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Restart Claude Desktop to connect the server.
Configuration
Ollama Settings
Default configuration in mcp_server.py
:
- Host: localhost
- Port: 1434
- Model: llama3.1
Database Settings
- Default DB:
anydb.sqlite
(created automatically) - Location: Same directory as the server
- Type: SQLite with foreign key constraints enabled
Usage Examples
Once integrated with Claude Desktop, you can use natural language:
Database Operations
- "Create a users table with id, name, email, and created_at fields"
- "Show me all active users from the last 30 days"
- "Insert a new product: iPhone 15, price $999, category Electronics"
- "Update all pending orders to processed where amount > 100"
- "Delete test users where email contains 'test'"
Vector Database & File Operations
- "Add this document to the knowledge base" (when attaching a file in Claude Desktop)
- "Search for information about machine learning algorithms"
- "Find documents related to user authentication and security"
- "What does the uploaded contract say about payment terms?"
- "Show me all documents I've added to the database"
- "Remove the old privacy policy document"
Architecture
Development
Project Structure
Key Components
Core Modules:
- main.py: Entry point with dependency checking and startup information
- mcp_server.py: MCP protocol implementation, tool registration, and request routing
- dbtool.py: Database operations, SQL generation, and data management
- filetool.py: Vector database operations, file processing, and semantic search
Business Logic Classes:
- DatabaseManager: Handles async SQLite operations and database connections
- DatabaseTools: High-level database operations with natural language support
- OllamaClient: Manages AI model communication for SQL generation
- VectorDatabaseManager: Manages ChromaDB operations and document embeddings
- FileTools: High-level file operations and semantic search functionality
Troubleshooting
Common Issues
- Server won't start: Check if Ollama is running on port 1434
- No tools showing in Claude: Verify MCP config path and restart Claude Desktop
- SQL errors: Check table names and ensure proper natural language descriptions
- Ollama connection failed: Confirm Ollama model is installed and accessible
Debug Mode
Run with Python's verbose mode for detailed logs:
License
This project is open source. See LICENSE file for details.
Contributing
- Fork the repository
- Create a feature branch
- Make your changes
- Add tests if applicable
- Submit a pull request
Support
For issues and questions:
- Check the troubleshooting section
- Review Ollama and MCP documentation
- Open an issue on the repository
This server cannot be installed
local-only server
The server can only run on the client's local machine because it depends on local resources.
Enables natural language database operations and semantic document search through SQLite and vector database integration. Converts plain English instructions into SQL queries and provides RAG capabilities for uploaded documents.
Related MCP Servers
- -securityAlicense-qualityProvides RAG capabilities for semantic document search using Qdrant vector database and Ollama/OpenAI embeddings, allowing users to add, search, list, and delete documentation with metadata support.Last updated -315TypeScriptApache 2.0
- -securityFlicense-qualityEnables querying log data stored in SQLite databases through the Model Context Protocol, allowing natural language interactions with log analysis.Last updated -Python
- AsecurityAlicenseAqualityAn AI-powered SQLite assistant that converts natural language to SQL queries with full schema awareness, enabling users to interact with databases using conversational language.Last updated -51PythonMIT License
- -securityFlicense-qualityA server that exposes SQLite database operations as tools, allowing natural language interactions with a database through LlamaIndex and Ollama LLM integration.Last updated -1Python