Connectto Google Sheets, YouTube, Postgres MCP Servers
Create powerful AI workflows by connecting multiple MCP servers including Google Sheets, YouTube, Postgres for enhanced automation capabilities in Klavis AI.
Google Sheets
Google Sheets is a web-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets online
Available Tools:
- google_sheets_create_spreadsheet
- google_sheets_get_spreadsheet
- google_sheets_write_to_cell
- +1 more tools
YouTube
Extract and convert YouTube video information to markdown format
Available Tools:
- get_youtube_video_transcript
Postgres
PostgreSQL is a powerful, open source object-relational database system
Available Tools:
- query
Quick Setup Guide
Follow these steps to connect LlamaIndex to these MCP servers
Create Your Account
Sign up for KlavisAI to access our MCP server management platform.
Configure Connections
Add your desired MCP servers to LlamaIndex and configure authentication settings.
Test & Deploy
Verify your connections work correctly and start using your enhanced AI capabilities.
LlamaIndex + KlavisAI Integration Snippets
import os
from klavis import Klavis
from klavis.types import McpServerName, ConnectionType
from llama_index.tools.mcp import (
BasicMCPClient,
get_tools_from_mcp_url,
aget_tools_from_mcp_url,
)
from llama_index.core.agent.workflow import FunctionAgent, AgentWorkflow
# Initialize clients
klavis_client = Klavis(api_key=os.getenv("KLAVIS_API_KEY"))
google_sheets_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.GOOGLE_SHEETS,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
youtube_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.YOUTUBE,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
postgres_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.POSTGRES,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
google_sheets_tools = await aget_tools_from_mcp_url(
google_sheets_mcp_instance.server_url,
client=BasicMCPClient(google_sheets_mcp_instance.server_url)
)
youtube_tools = await aget_tools_from_mcp_url(
youtube_mcp_instance.server_url,
client=BasicMCPClient(youtube_mcp_instance.server_url)
)
postgres_tools = await aget_tools_from_mcp_url(
postgres_mcp_instance.server_url,
client=BasicMCPClient(postgres_mcp_instance.server_url)
)
google_sheets_agent = FunctionAgent(
name="google_sheets_agent",
tools=google_sheets_tools,
llm=llm,
)
youtube_agent = FunctionAgent(
name="youtube_agent",
tools=youtube_tools,
llm=llm,
)
postgres_agent = FunctionAgent(
name="postgres_agent",
tools=postgres_tools,
llm=llm,
)
workflow = AgentWorkflow(
agents=[google_sheets_agent, youtube_agent, postgres_agent],
root_agent="google_sheets_agent",
)Frequently Asked Questions
Everything you need to know about connecting to these MCP servers
Ready to Get Started?
Join developers who are already using KlavisAI to power their LlamaIndex applications with these MCP servers.
Start For Free