SiYuan Search Tool icon

SiYuan Search Tool

Use this tool to search and query the SiYuan knowledge base. Use "fullText" to find content by keywords, "sqlQuery" for advanced database queries, "searchByTag" to find tagged blocks, or "searchByAttribute" to find blocks by attribute values.

SQL Query

AI-generated

Summary

Execute a custom SQL query on the SiYuan database to retrieve data according to the specified SQL statement.

Inputs

  • SQL Statement (required) — A SQL query string to run on the SiYuan database, e.g., 'SELECT * FROM blocks LIMIT 10'.

Output shape

a list of records resulting from the executed SQL query

The output contains database rows returned by the query, or a success indication if the query returns no data. Errors related to SQL syntax or query execution will be surfaced as node errors.

Links

Discussion