filesystem vs ChatSQL
Side-by-side comparison to help you pick between these two MCP servers.
filesystem by modelcontextprotocol | ChatSQL by thomasjerard | |
|---|---|---|
| Stars | ★ 85,748 | ★ 0 |
| 30d uses | — | — |
| Score | 77 | 30 |
| Official | ✓ | — |
| Categories | File SystemDeveloper ToolsProductivity | DatabaseAI / LLM ToolsDeveloper Tools |
| Language | TypeScript | Python |
| Last commit | this month | 11 mo ago |
filesystem · Summary
A feature-rich MCP server for filesystem operations with dynamic directory access control.
ChatSQL · Summary
ChatSQL converts natural language questions to PostgreSQL queries using Gemini and FastMCP protocol.
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
ChatSQL · Use cases
- Business analysts querying databases without SQL knowledge
- Quick data exploration by asking questions instead of writing queries
- Educational tool for learning SQL through natural language interaction
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.
ChatSQL · Install
Installation
- Clone the repository:
git clone https://github.com/thomasjerard/ChatSQL.git
cd chatSQL- Create a .env file with your database credentials and Gemini API key:
DB_NAME=chattosql
DB_USER=postgres
DB_PASS=yourpassword
DB_HOST=localhost
DB_PORT=5432
GEMINI_API_KEY=your-gemini-api-key- Run the server in one terminal:
./run_server.sh- Run the client in another terminal:
./run_client.shTo use with Claude Desktop, add to your config.json:
{
"mcpServers": {
"chatsql": {
"command": "python",
"args": ["path/to/chatsql/server.py"]
}
}
}