Snowflake Basic MCP integration
Lists databases, schemas, and tables, describes columns and samples their values, then runs SQL against the live warehouse on request.
6actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Explore columns
Lyro samples distinct column values from Snowflake. Analysts explore data without writing SQL queries.
Show databases
Lyro lists all Snowflake databases available. Teams navigate their data warehouse during conversations.
Show schemas
Lyro retrieves all schemas within a database. Analysts explore Snowflake structure instantly without manual lookup.
How businesses use Snowflake Basic + Lyro
Each card is one request a support team gets, and the Snowflake Basic actions Lyro runs to close it.
Find the right table before writing a query
Lyro walks the databases and schemas the account can reach, then lists the tables in one with their row counts and sizes, so a question about where a metric lives is answered without opening the console.
Show DatabasesShow SchemasShow TablesExplain what a table actually contains
Lyro reads each column's name, data type, nullability, default, and key status, then pulls a sample of distinct values, so the shape of a table is clear before anyone builds on it.
Describe TableExplore ColumnsShow TablesAnswer a reporting question with live SQL
Lyro sets the database and schema context and executes the query there, so the figure someone asks for comes back from the warehouse instead of a spreadsheet copy of it.
Run QueryShow SchemasDescribe TableGround a customer answer in warehouse data
Lyro confirms the column layout, queries the single row that matches the customer, and carries the result into the conversation, handing off to a human agent with full history when the case needs judgment.
Describe TableExplore ColumnsRun Query
How it works
Get started in 3 steps
Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Lyro reads the Snowflake Basic actions it has and picks the ones a request needs.
Connect Snowflake Basic
Authorize the Snowflake Basic account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Lyro maps it to the Snowflake Basic actions that close it and chains as many as the request needs.
Watch it work
The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.
Get started free
Snowflake Basic · Lyro
What can you do in Snowflake Basic without me setting anything up?
These, right away:
- Describe table
- Explore columns
- Run query
Great, let's start with the first one.
FAQ
Everything else about Snowflake Basic
Setup, permissions, and the limits of what Lyro can do inside Snowflake Basic.
Most of the toolkit only reads: Describe Table, Explore Columns, Show Databases, Show Schemas, and Show Tables all return metadata or sampled values. Run Query executes whatever SQL it is given, so whether anything can be written is decided by the privileges on the Snowflake role you connect, not by the integration.
Every action available in Snowflake Basic
All 6 actions your agent can call on Snowflake Basic, straight from the live MCP connection.
Describe table
Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.
Explore columns
Retrieves a sample of distinct values for specified columns from a Snowflake table.
Run query
Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.
Show databases
Retrieves a list of all databases available in the Snowflake account.
Show schemas
Retrieves a list of all schemas within a specified Snowflake database.
Show tables
Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.
The tools Snowflake Basic sits next to
Same connection, same setup. Pick the next one your team already uses.
Agenty
Extracts structured data from a URL, starts scraping agents and returns their results, maintains input lists, and controls agent schedules.
Currents api
Pulls the real-time article feed or runs a filtered keyword search, returning titles, authors and publication dates.
Google Analytics
Runs GA4 reports on request, checks realtime traffic, creates custom dimensions and audience exports, and audits how a property is wired up.
Microsoft Power Bi
Runs DAX queries against the model, triggers and tracks dataset refreshes, generates report embed tokens, and manages workspace access.
Plausible Analytics
Queries visitor stats by dimension and date range, reports live visitor counts, and records server-side pageviews or custom events.
Supadata
Returns video transcripts from the major platforms, converts web pages to Markdown, maps a site's URLs, and reads YouTube metadata.
Ready to connect Snowflake Basic?
Authorize the account and your agent has all 6 actions from the first conversation.