What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the Google Sheets MCP server?
Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
How to install Google Sheets
Copy-paste configuration for popular MCP clients.
GOOGLE_CLIENT_IDrequiredGoogle OAuth client ID (required for OAuth authentication modes)
GOOGLE_CLIENT_SECRETsecretGoogle OAuth client secret (optional for public clients)
GOOGLE_SERVICE_ACCOUNT_KEY_FILEPath to service account JSON key file (required for service-account auth mode)
AUTH_MODEAuthentication mode
HEADLESSDisable browser auto-open, return auth URL instead (true/false)
REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)
RESOURCE_STORE_URIResource store URI for exported files (file://)
PORTHTTP server port (overrides --port)
BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)
LOG_LEVELLogging level
DCR_MODEDynamic Client Registration mode
DCR_VERIFY_URLExternal verification endpoint URL (required for external DCR mode)
DCR_STORE_URIDCR client storage URI (for self-hosted DCR mode)
{
"mcpServers": {
"mcp-sheets": {
"command": "npx",
"args": [
"-y",
"@mcp-z/mcp-sheets",
"-y",
"--auth",
"--headless",
"--redirect-uri",
"--service-account-key-file",
"--resource-store-uri",
"--base-url",
"--log-level"
],
"env": {
"GOOGLE_CLIENT_ID": "<YOUR_GOOGLE_CLIENT_ID>",
"GOOGLE_CLIENT_SECRET": "<YOUR_GOOGLE_CLIENT_SECRET>",
"GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
"AUTH_MODE": "<YOUR_AUTH_MODE>",
"HEADLESS": "<YOUR_HEADLESS>",
"REDIRECT_URI": "<YOUR_REDIRECT_URI>",
"RESOURCE_STORE_URI": "<YOUR_RESOURCE_STORE_URI>",
"PORT": "<YOUR_PORT>",
"BASE_URL": "<YOUR_BASE_URL>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>",
"DCR_MODE": "<YOUR_DCR_MODE>",
"DCR_VERIFY_URL": "<YOUR_DCR_VERIFY_URL>",
"DCR_STORE_URI": "<YOUR_DCR_STORE_URI>"
}
}
}
}Related MCP servers
Google Drive integration with file operations, folder navigation, search, and sharing
Gmail integration with OAuth authentication, message search, batch operations, and Sheets export
Outlook integration with OAuth, message search, batch operations, and calendar management
MCP server for creative PDF generation with full emoji, Unicode, and offline support
Consulta o Bulário Eletrônico da ANVISA: bulas, registros, tarjas e apresentações.
View repository →
Consulta o CNES (estabelecimentos de saúde): profissionais, leitos, equipamentos, serviços.
View repository →