Skip to main content
Glama
deenesjakoruzh
JacobW2000

sqlite-mcp-server

by JacobW2000
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Local

Employee Database MCP Server

一个小型 Python 项目，让 Claude Desktop 通过模型上下文协议（MCP）与 SQLite 员工数据库交互。

我构建这个项目是为了学习 AI 助手如何利用外部工具来检索和修改结构化数据。

功能

该服务器为 Claude 提供了一套用于处理员工数据的工具。例如，Claude 可以：

  • 添加员工

  • 按 ID 查找员工

  • 按姓名搜索员工

  • 列出所有员工

  • 更新员工薪资

  • 删除员工

  • 查找薪资最高的员工

  • 计算平均薪资

  • 列出公司部门

  • 按部门统计员工人数

  • 获取公司整体统计信息

由于这些工具通过 MCP 暴露，我可以用自然语言向 Claude 提问，而无需自己编写 SQL 查询。

Related MCP server: SQLite MCP Server

工作原理

该项目分为三个主要部分：

Claude Desktop
      |
      | MCP
      v
   server.py
      |
      v
  database.py
      |
      v
   SQLite

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityMaintained
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • MCP Database Server

    msathiyakeerthi
    A
    license
    Not graded
    quality
    C
    maintenance
    Provides database access capabilities to Claude with support for both SQLite and SQL Server databases. It enables users to manage schemas, execute SQL queries, and export results through natural language interaction.
    987 npm
    MIT

  • SQLite MCP Server

    sparxit
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables natural language interaction with local SQLite databases through Claude Desktop, translating plain English queries into SQL for data analysis and exploration.
    3
    MIT

  • MCP Database Server

    lukhim
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables Claude to query and manage databases (SQLite, SQL Server, PostgreSQL, MySQL) through natural language, supporting read/write operations and schema management.
    987 npm
    MIT

  • MCP Server for Enterprise DB

    swetanjana
    F
    license
    Not graded
    quality
    C
    maintenance
    Enables Claude Desktop to securely query a SQLite HR database, providing tools to check leave balances and list pending approvals through natural language.
    -