# snowflake-mcp
Snowflake MCP server built with FastMCP.

## Quick Start

### Windows PowerShell

```powershell
python -m venv .venv
.venv\Scripts\activate
pip install -r requirements.txt
```

### macOS / Linux

```bash
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
```

## Configuration

Create an empty `.env` file in the project root with follwing credentials.

Provide credentials through environment variables configuration.

You can also copy the values from `.env.example` into `.env` and fill in your Snowflake details.

```bash
- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USER
- SNOWFLAKE_PASSWORD
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_DATABASE
- SNOWFLAKE_SCHEMA
- SNOWFLAKE_ROLE
- SNOWFLAKE_ALLOW_WRITE=false
```

Keep `SNOWFLAKE_ALLOW_WRITE=false` unless you want to allow write operations.

Use the VS Code MCP start button in `.vscode/mcp.json` to launch the server.

## Tools

- list_databases
- list_schemas
- list_tables
- describe_table
- read_query
- write_query
- create_table
- append_insight