How to Use the Materialize (Streaming SQL DB) MCP in VS Code Copilot

Q: How do I share the Materialize (Streaming SQL DB) config with my team in VS Code Copilot?

You commit a .vscode/mcp.json file containing the server configuration to your Git repository. Every developer on your team who opens the project in VS Code gets automatic access to the MCP tools.

Q: Can VS Code Copilot create materialized views in Materialize (Streaming SQL DB)?

Yes, the agent uses the executesql tool to run CREATE MATERIALIZED VIEW statements directly on your active instance. The MCP integration runs the statements directly, letting you build and test real-time data pipelines from the chat interface.

Q: How do I check active compute engines in Materialize (Streaming SQL DB) using VS Code Copilot?

You run the listclusters tool through the chat interface. Copilot fetches the list of active compute resources, showing you their sizes and operational states.

Run streaming SQL and manage compute clusters directly inside VS Code Copilot.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Materialize (Streaming SQL DB) MCP to VS Code Copilot

Create your Vinkius account to connect Materialize (Streaming SQL DB) to VS Code Copilot and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Materialize (Streaming SQL DB) with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Run streaming SQL statements in VS Code Copilot

The `execute_sql` tool executes live queries against your streaming database directly from the Copilot chat panel. Developers can test complex materialized views and inspect real-time data flows without opening an external SQL client. This lets your agent pull real schema definitions and query results directly into your active workspace. Your team writes database migrations using actual live context rather than outdated documentation.

Manage compute engines using the VS Code Copilot MCP Server

The `create_cluster` tool provisions dedicated compute resources of any size, from xs to xl, directly from your editor. Your team can scale up compute for heavy backfills and scale down when the work is done. To keep track of your team's cloud footprint, the `list_clusters` tool displays all active compute engines and their sizes. Copilot reads this data to help you target the right cluster for your streaming workloads.

Audit streaming pipeline health instantly

The `check_health` tool queries the operational status of your streaming database instance to verify that sources and sinks are running smoothly. It catches replication lag and connection drops before you commit code. Instead of jumping to a cloud dashboard to debug a broken stream, you ask Copilot to run a health check. The agent analyzes the system state and tells you exactly which Kafka topic or database connector is failing.

Setup guide

Set up Materialize (Streaming SQL DB) MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Materialize (Streaming SQL DB) MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Materialize (Streaming SQL DB) tools listed. Try asking: "List my recent Materialize (Streaming SQL DB) transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "materialize-streaming-sql-db-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Materialize. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Materialize (Streaming SQL DB) now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Materialize (Streaming SQL DB) MCP in VS Code Copilot

You commit a `.vscode/mcp.json` file containing the server configuration to your Git repository. Every developer on your team who opens the project in VS Code gets automatic access to the MCP tools.

Yes, the agent uses the `execute_sql` tool to run `CREATE MATERIALIZED VIEW` statements directly on your active instance. The MCP integration runs the statements directly, letting you build and test real-time data pipelines from the chat interface.

You run the `list_clusters` tool through the chat interface. Copilot fetches the list of active compute resources, showing you their sizes and operational states.

The database engine returns the error through the MCP channel. Copilot reads this output and suggests the corrected SQL syntax immediately.

All database queries and connection details are managed through secure, ephemeral MCP transport layers. Your raw SQL commands and streaming results are never cached or used to train public AI models.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript