Downloads
AI assistant

Tools and prompts

An MCP server can offer three kinds of things: tools the assistant can call, resources it can read, and prompts you can pick. This server uses all three.

Database tools

ToolWhat it does
list_databasesShows the databases you can explore.
use_databasePicks a default database for the rest of the chat (not on a locked connection).
describe_databaseLists tables and views, row counts, and the exact name to use in queries.
describe_tableColumns, types, primary and foreign keys.
sample_rowsThe first few rows of a table.
run_queryRuns one read-only SELECT and returns the result.
check_querySays whether a query is allowed and points out common mistakes, without running it.

Every database tool takes an engine option: sqlserver (default) or mariadb. They hold the same data, with different SQL dialects.

Knowledge tools: DAX, SQL, Power Query M and Power BI

ToolWhat it does
search_dax_knowledgeFinds how to do something in DAX, SQL, Power Query M, Power Pivot or Power BI, with working code.
get_dax_guideReads a topic or one section in full.
list_dax_topicsLists the topics and their sections.
lint_daxChecks a formula for common mistakes.

The same guides are plain Markdown for any tool: llms.txt (index), llms-full.txt (everything in one file) and agents.md (how an agent should use LearnSQL). See also Help with DAX and Power BI.

Resources

In many apps you can attach a resource to a chat so the assistant has the schema up front.

Prompts

In most apps, prompts appear as slash commands or in a "+" menu.