
how to user queries with appwrite mcp without getting Appwrite Error: Invalid query: Syntax error
?
database_list_documents function with such query:
TypeScript
{
"database_id": "database_id",
"collection_id": "collection_id",
"queries": [
"equal(\"user\",\"user_id\")",
"equal(\"achievement\",\"achievement_id\")",
"limit(1)"
]
}
returns error
TL;DR
Developers need to include the method and attribute parameters in their MCP queries for Appwrite. Utilize the correct syntax as outlined in the documentation provided at https://appwrite.io/docs/apis/rest#queries-string-format to avoid receiving the `Appwrite Error: Invalid query: Syntax error`.
In the `database_list_documents` function, ensure the query follows the correct format. For example:
```
{
"database_id": "database_id",
"collection_id": "collection_id",
"queries": [
"equal(\"user\",\"user_id\")",
"equal(\"achievement\",\"achievement_id\")",
"limit(
You need to include the method and attribute parameters. Check: https://appwrite.io/docs/apis/rest#queries-string-format
Recommended threads
- Is Quick Start for function creation wor...
I am trying to create a Node.js function using the Quick Start feature. It fails and tells me that it could not locate the package.json file. Isn't Quick Start ...
- Recourse limit for your project has exce...
Hi, when I open my app, I am getting a resource limit exceeded error. Is this related to the appwrite side or is it related to my side?
- Update Document - GO
Hello Appwrite team, currently I am having trouble updating collection documents on GOlang . Can you help me with that? --- the README on GitHub is stale whil...
