SQLite Database Demo

Created By
anhnx000a year ago
Some examples to build server, client test in model context protocol. Một số ví dụ sử dụng MCP
Overview

what is SQLite Database Demo?

SQLite Database Demo is a project that demonstrates the usage of SQLite database with asynchronous support in a FastMCP application.

how to use SQLite Database Demo?

To use the SQLite Database Demo, clone the repository, install the required dependencies, and start the server using the command python server.py. The database will be automatically initialized with sample data on the first run.

key features of SQLite Database Demo?

  • Async SQLite database operations using aiosqlite
  • Automatic database initialization with sample data
  • Type-safe database context management
  • Proper connection lifecycle handling

use cases of SQLite Database Demo?

  1. Building server-client applications with database support.
  2. Demonstrating async database operations in Python.
  3. Learning how to manage database connections in a FastMCP application.

FAQ from SQLite Database Demo?

  • What is required to run this project?

You need Python 3.7+ and pip to install the dependencies.

  • How do I modify the database schema?

You can edit the _init_db() method in database.py to change the schema or add new tables.

  • What libraries are used in this project?

The project uses aiosqlite for async database operations, along with pandas and numpy for data manipulation.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
anhnx000
Star
0
Language
Python
License
-

Recommend Servers

View All
Shadcn Space MCP
@shadcnspace

Integrate the shadcn/ui MCP server from shadcn space into your IDE to generate accurate, production-ready Shadcn UI components. Official Model Context Protocol (MCP) server for [Shadcn Space](https://shadcnspace.com). This MCP server allows AI-powered IDEs and agents to discover, search, and install **Shadcn Space** UI blocks directly into your projects - no copy-paste required. ## Install MCP configuration. ```bash npx shadcnspace-cli install <client> ``` ### Supported Clients - [x] cursor - [x] windsurf - [x] claude - [x] cline - [x] antigravity ## Manual Installation Add to your IDE's MCP config: ```json { "mcpServers": { "shadcnspace-mcp": { "command": "npx", "args": ["-y", "shadcnspace-mcp@latest"] } } } ``` For more information visit our documentation of [**How to use MCP Server**](https://shadcnspace.com/docs/getting-started/mcp-server-docs) ## Available Tools The server provides the following tools callable via MCP: | Tool Name | Description | |-----------|-------------| | `listBlocks` | Provides a comprehensive list of all shadcnspace blocks. | | `listComponents` | Provides a comprehensive list of all shadcnspace components. | | `getBlockInstall` | Returns the official installation command for a specific Shadcn Space block. | | `searchBlocks` | Search Shadcn Space blocks using keywords or tags. | | `listInstalledBlocks` | Lists all blocks that are currently installed in the project and get their files. | ### Available Prompts The server provides the following prompts callable via MCP: | Prompt/Command | Description | |----------------|-------------| | `search` | Find specific UI block by name. | | `create-ui` | Create a new UI block using our exisitng blocks. | ## Example Usage Once configured, you can ask questions like: > "List all available UI blocks" > "Give me the code for the accordion-01 component" > "Create a landing page for a coffee shop using a hero-01 block, a 3-column feature grid, and a dark-themed footer." ## Credits Created by [shadcnspace](https://shadcnspace.com). [Shadcn MCP](https://shadcnspace.com/mcp) [MIT](LICENSE)

2 days ago