iamayuppie/AnyDbApp
If you are the rightful owner of AnyDbApp 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 AnyDB MCP Server is a Model Context Protocol server that leverages natural language processing to perform intelligent database operations, integrating SQLite databases with Ollama for AI-powered SQL generation and execution.
Tools
Functions exposed to the LLM to take actions
query_entity
Query any table with natural language instructions.
insert_entity
Insert records into any table using natural language descriptions.
update_entity
Update records in any table with conditions.
delete_entity
Delete records from any table with optional conditions.
create_table
Create new tables with AI-generated schemas.
sql_query
Execute raw SQL SELECT queries directly.
sql_execute
Execute raw SQL modification queries (INSERT, UPDATE, DELETE, CREATE, etc.).
add_file_to_vector_db
Add a file to the vector database for semantic search and RAG.
search_vector_db
Search the vector database for relevant file content using semantic similarity.
list_vector_files
List all files stored in the vector database.
remove_file_from_vector_db
Remove a file from the vector database.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client