Snowflake · Capability

Snowflake Data Management

Unified workflow for managing databases, schemas, tables, views, dynamic tables, iceberg tables, and event tables. Used by Data Engineers and Database Administrators to create, organize, and maintain data structures.

Run with Naftiko SnowflakeData ManagementData Engineering

What You Can Do

GET
List databases — List all databases
/v1/databases
POST
Create database — Create a database
/v1/databases
GET
Fetch database — Fetch a database
/v1/databases/{name}
DELETE
Delete database — Delete a database
/v1/databases/{name}
GET
List schemas — List schemas
/v1/schemas
POST
Create schema — Create a schema
/v1/schemas
GET
List tables — List tables
/v1/tables
POST
Create table — Create a table
/v1/tables
GET
List views — List views
/v1/views
POST
Create view — Create a view
/v1/views
GET
List dynamic tables — List dynamic tables
/v1/dynamic-tables
POST
Create dynamic table — Create a dynamic table
/v1/dynamic-tables
GET
List iceberg tables — List Iceberg tables
/v1/iceberg-tables
POST
Create iceberg table — Create an Iceberg table
/v1/iceberg-tables

MCP Tools

list-databases

List all accessible databases

read-only
create-database

Create a new database

fetch-database

Fetch database details by name

read-only
delete-database

Delete a database

clone-database

Clone a database

undrop-database

Restore a dropped database

list-schemas

List schemas in a database

read-only
create-schema

Create a new schema

fetch-schema

Fetch schema details

read-only
delete-schema

Delete a schema

list-tables

List tables in a schema

read-only
create-table

Create a new table

fetch-table

Fetch table details

read-only
delete-table

Delete a table

list-views

List views in a schema

read-only
create-view

Create a new view

list-dynamic-tables

List dynamic tables

read-only
create-dynamic-table

Create a dynamic table

suspend-dynamic-table

Suspend a dynamic table

resume-dynamic-table

Resume a dynamic table

list-iceberg-tables

List Iceberg tables

read-only
create-iceberg-table

Create an Iceberg table

list-event-tables

List event tables

read-only
create-event-table

Create an event table

list-external-volumes

List external volumes

read-only
create-external-volume

Create an external volume

APIs Used

snowflake-database snowflake-schema snowflake-table snowflake-view snowflake-dynamic-table snowflake-iceberg-table snowflake-event-table snowflake-external-volume