semvec/pypi-packages huggingface dataset:
pixeltable-pgserver 0.5.1
Embedded Postgres Server for Pixeltable
Requires Python: >=3.10

<picture class="github-only">
  <source media="(prefers-color-scheme: light)" srcset="https://github.com/user-attachments/assets/e9bf82b2-cace-4bd8-9523-b65495eb8131">
  <source media="(prefers-color-scheme: dark)" srcset="https://github.com/user-attachments/assets/c5ab123e-806c-49bf-93e7-151353719b16">
  <img alt="Pixeltable Logo" src="https://github.com/user-attachments/assets/e9bf82b2-cace-4bd8-9523-b65495eb8131" width="40%">
</picture>

<div>
<br>
</div>

[![License](https://img.shields.io/badge/License-Apache%202.0-darkblue.svg)](https://opensource.org/licenses/Apache-2.0)
[![pytest status](https://github.com/pixeltable/pixeltable-pgserver/actions/workflows/build-and-test.yml/badge.svg)](https://github.com/pixeltable/pixeltable-pgserver/actions)
[![PyPI Package](https://img.shields.io/pypi/v/pixeltable-pgserver?color=4D148C)](https://pypi.org/project/pixeltable-pgserver/)

__pixeltable-pgserver__ is an embedded Postgres server used internally by
[Pixeltable](https://github.com/pixeltable/pixeltable). It is a fork of Oscar Moll's
[pgserver](https://github.com/orm011/pgserver), which is itself a fork of Michel Pelletier's
[postgresql-wheel](https://github.com/michelp/postgresql-wheel).

For Pixeltable documentation and installation instructions, visit the main
[Pixeltable repository](https://github.com/pixeltable/pixeltable).
mcp-server-sql-inspector 0.1.3
A Model Context Protocol server that enables AI to inspect SQL databases and analyze query performance.
Requires Python: <4.0,>=3.10

# MCP Server SQL Inspector

[![PyPI version](https://img.shields.io/pypi/v/mcp-server-sql-inspector.svg)](https://pypi.org/project/mcp-server-sql-inspector/)

A Model Context Protocol (MCP) server that enables AI to inspect SQL databases and analyze query performance.

## Tools

- **list_tables**: List tables in the database.
- **get_schema**: Get schema definition for one or more tables.
  - `table_names` (list): List of table names to inspect.
- **get_table_stats**: Get estimated row count for a table.
- **run_explain**: Analyze a query execution plan.
  - `query`: The SQL query to analyze (SELECT only).
  - `just_explain_plan` (optional): If true, gets the plan without running the query (default: False).

## Installation

### Using `uv` (Recommended)

When using `uv` no installation is necessary. You can run the server directly:

```bash
uvx mcp-server-sql-inspector
```

### Configuration with Claude Desktop

Add this to your `claude_desktop_config.json`:

```json
{
  "mcpServers": {
    "sql-inspector": {
      "command": "uvx",
      "args": ["mcp-server-sql-inspector"],
      "env": {
        "DATABASE_URL": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}
```

### Local Development Configuration

If you are developing the server locally and want to test changes in Claude Desktop:

```json
{
  "mcpServers": {
    "sql-inspector": {
      "command": "/absolute/path/to/mcp-server-sql-inspector/.venv/bin/mcp-server-sql-inspector",
      "args": [],
      "env": {
        "DATABASE_URL": "sqlite:///demo.db"
      }
    }
  }
}
```

### From Source

```bash
git clone <repository-url>
cd mcp-server-sql-inspector
poetry install --extras all
```

### Docker

Build the image:
```bash
docker build -t mcp-server-sql-inspector .
```

Run the container:
```bash
docker run -i --rm -e DATABASE_URL="postgresql://user:password@host:port/dbname" mcp-server-sql-inspector
```

#### Docker Configuration for Claude Desktop

```json
{
  "mcpServers": {
    "sql-inspector": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e", "DATABASE_URL=postgresql://user:password@host:port/dbname",
        "mcp-server-sql-inspector"
      ]
    }
  }
}
```

## Configuration

The server requires a `DATABASE_URL` environment variable to connect to your database.

Supported database protocols (requires appropriate drivers):
- PostgreSQL: `postgresql://...`
- MySQL: `mysql://...`
- MSSQL: `mssql+pyodbc://...`
- SQLite: `sqlite:///...`

## Development

1. Install dependencies:
   ```bash
   poetry install --extras all
   ```

2. Run the server:
   ```bash
   export DATABASE_URL="sqlite:///test.db"
   poetry run mcp-server-sql-inspector
   ```

## License

[MIT](LICENSE)
iflow-mcp-sourangshupal-custompymcpserver 0.1.5
Building your own Custom MCP Servers
Requires Python: >=3.11

# 🚀 Build Custom MCP Servers 📝☀️📰

## 📖 Project Description

This project demonstrates a simple MCP Servers built using the MCP `mcp[cli]` Python SDK. It provides several tools exposed through the MCP server:

*   **Note Management:** Add, read, retrieve the latest, and generate summaries of notes stored locally.
*   **Weather Information:** Fetch current weather data for a specified city using the WeatherAPI.com service.
*   **News Search:** Perform news searches using the Brave Search API.

It utilizes API keys stored in a `.env` file for external services.

## 🛠️ Setup Instructions

Follow these steps to get the FastMCP agent running:

1.  **Prerequisites:**
    *   Python 3.12 installed.
    *   A virtual environment manager (like `venv`, `pipenv`, `poetry`, or `uv`) is recommended.

2.  **Clone the Repository (if you haven't already):**
    ```bash
    # Make sure you are in the correct parent directory
    git clone https://github.com/sourangshupal/Build-Custom-MCP-Servers # Or use the current directory if already cloned
    cd Build-Custom-MCP-Servers 
    ```

3.  **Set up Virtual Environment & Install Dependencies:**
    *   Install dependencies (assuming uv, based on uv.lock, otherwise adjust for pip/poetry):
        ```bash
        uv sync
        uv lock
        source .venv/bin/activate  # On Windows use `.venv\Scripts\activate`
        ```
    *   OR
        ```bash
        pip install uv # if you don't have uv
        uv pip install -r requirements.txt # Or uv sync if using pyproject.toml directly
        # If not using uv, likely: pip install -r requirements.txt or poetry install or pip install .
        ```

4.  **Configure Environment Variables:**
    *   Copy the example environment file:
        ```bash
        cp .env.example .env
        ```
    *   Edit the newly created `.env` file and add your API keys:
        ```dotenv
        WEATHER_API_KEY="YOUR_WEATHER_API_KEY"
        BRAVE_API_KEY="YOUR_BRAVE_API_KEY"
        ```

5.  **Run the Agent:**
    *   Execute the main script:
        ```bash
        mcp install main.py
        ```
    *   The FastMCP server should be added to Claude Desktop.

        ```bash
        mcp dev main.py
        ```
    *   Debug the MCP Server

## ✨ Features

*   Note-taking capabilities (add, read, latest, summarize) 📝
*   Current weather fetching ☀️
*   Brave Search integration for news 📰
*   Configuration via `.env` file 🔑
*   Built with `mcp[cli]` ⚙️

## 🤝 Contributing

Contributions are welcome! Please feel free to submit pull requests or open issues.