redshift-mcp-server vs filesystem
Side-by-side comparison to help you pick between these two MCP servers.
redshift-mcp-server by amitds1997 | filesystem by modelcontextprotocol | |
|---|---|---|
| Stars | ★ 1 | ★ 85,748 |
| 30d uses | — | — |
| Score | 28 | 77 |
| Official | — | ✓ |
| Categories | DatabaseDeveloper Tools | File SystemDeveloper ToolsProductivity |
| Language | Python | TypeScript |
| Last commit | 10 mo ago | this month |
redshift-mcp-server · Summary
A simple MCP server for executing SQL queries on Amazon Redshift clusters with username/password authentication.
filesystem · Summary
A feature-rich MCP server for filesystem operations with dynamic directory access control.
redshift-mcp-server · Use cases
- Querying Redshift data from AI assistants via MCP
- Automating data analysis workflows with Redshift integration
- Non-developer access to Redshift through conversational interfaces
filesystem · Use cases
- Enable AI models to read and write project files during development
- Allow Claude or other MCP clients to browse and analyze codebases
- Provide secure sandboxed access to specific directories for content generation
redshift-mcp-server · Install
Installation
- Clone the repository to your local machine
- Install uv following the [official guide](https://docs.astral.sh/uv/getting-started/installation/)
- Configure your MCP client with the following settings:
{
"command": "uv",
"args": [
"--directory",
"<path_to_redshift_mcp>",
"run",
"server.py"
],
"env": {
"REDSHIFT_DB": "<db-name>",
"REDSHIFT_USER": "<redshift_user>",
"REDSHIFT_PASSWORD": "<redshift_password>",
"REDSHIFT_HOST": "<redshift-host-uri>",
"REDSHIFT_PORT": "5439"
}
}filesystem · Install
Installation
Using NPX
{
"mcpServers": {
"filesystem": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-filesystem",
"/path/to/allowed/directory"
]
}
}
}Using Docker
{
"mcpServers": {
"filesystem": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--mount", "type=bind,src=/path/to/allowed/dir,dst=/projects/allowed/dir",
"mcp/filesystem",
"/projects"
]
}
}
}VS Code Extension
Click the installation buttons in the README to install directly in VS Code.