PHP download

Download the PHP package momodemo333/php-mcp-postgresql without Composer

On this page you can find all versions of the php package momodemo333/php-mcp-postgresql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download momodemo333/php-mcp-postgresql
More information about momodemo333/php-mcp-postgresql
Files in momodemo333/php-mcp-postgresql

Vendor momodemo333
Package php-mcp-postgresql
Short Description PostgreSQL MCP Server for Claude Code - Secure and configurable PostgreSQL integration via Model Context Protocol
License MIT
Homepage https://github.com/momodemo333/php-mcp-postgresql

Keywords database postgresql pgsql postgres ai mcp model-context-protocol claude-code php-mcp

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of momodemo333/php-mcp-postgresql

Informations about the package php-mcp-postgresql

🐘 PHP MCP PostgreSQL Server

PostgreSQL MCP Server for Claude Code - Secure and configurable PostgreSQL integration via Model Context Protocol.

🎉 Version 1.0.0-beta: Core functionality complete! Production testing in progress.

🚀 Features

🔒 Secure by Default - Read-only operations by default, write operations require explicit permission
🎯 PostgreSQL Native - Full support for JSONB, arrays, CTEs, window functions, and more
⚡ High Performance - Connection pooling, prepared statements, query timeouts
📊 Schema Introspection - Explore databases, tables, columns, indexes
🔧 Flexible Configuration - Environment variables, .env files, multi-database support
🛡️ Built-in Protection - SQL injection prevention, dangerous keyword blocking, result limits

📦 Requirements

PHP 8.1 or higher
PostgreSQL 12 or higher
Composer
PHP extensions: ext-pdo, ext-pdo_pgsql

🔧 Installation

1. Clone the Repository

2. Install Dependencies

3. Configure Environment

⚙️ Configuration

Environment Variables

Variable	Description	Default
`PGSQL_HOST`	PostgreSQL server host	localhost
`PGSQL_PORT`	PostgreSQL server port	5432
`PGSQL_USER`	Database username	postgres
`PGSQL_PASS`	Database password	(empty)
`PGSQL_DB`	Database name (optional for multi-db)	(empty)
`ALLOW_INSERT_OPERATION`	Enable INSERT queries	false
`ALLOW_UPDATE_OPERATION`	Enable UPDATE queries	false
`ALLOW_DELETE_OPERATION`	Enable DELETE queries	false
`QUERY_TIMEOUT`	Query timeout in seconds	30
`MAX_RESULTS`	Maximum rows returned	1000
`CONNECTION_POOL_SIZE`	Max concurrent connections	5
`LOG_LEVEL`	Logging level (DEBUG/INFO/WARN/ERROR)	INFO

Claude Code Configuration

Add to your Claude Code settings (claude-code-settings.json):

See examples/ for more configuration examples.

🛠️ Available Tools

Database Management

pgsql_list_databases - List all available databases
pgsql_list_tables - List tables in a database
pgsql_describe_table - Get detailed table structure
pgsql_server_status - Get server status and statistics

Query Execution

pgsql_select - Execute SELECT queries safely
pgsql_insert - Insert data (requires permission)
pgsql_update - Update data (requires permission)
pgsql_delete - Delete data (requires permission)
pgsql_execute_query - Execute custom queries (with validation)

🧪 Testing

Quick Test

Docker Test Environment

The project includes a complete Docker test environment:

🔒 Security

Default Security Features

Read-only by default - All write operations disabled unless explicitly enabled
Prepared statements - Prevents SQL injection attacks
Query validation - Blocks dangerous keywords and operations
Result limits - Prevents memory exhaustion from large result sets
Connection timeouts - Prevents hanging queries
Schema restrictions - Limit access to specific schemas

Best Practices

Never enable write operations in production unless absolutely necessary
Use read-only database users when possible
Set appropriate MAX_RESULTS and QUERY_TIMEOUT values
Review logs regularly for suspicious activity
Keep the server updated with security patches

🎆 PostgreSQL-Specific Features

JSONB Support

Array Support

Advanced Features

Common Table Expressions (CTEs)
Window functions
RETURNING clause on INSERT/UPDATE/DELETE
Materialized views
Full-text search
Custom types and domains

📝 Documentation

Installation Guide
Configuration Reference
MCP Tools Documentation
Troubleshooting
Migration Plan
Implementation Status

🤝 Contributing

Contributions are welcome! Please:

Fork the repository
Create a feature branch
Write tests for new functionality
Ensure all tests pass
Submit a pull request

📄 License

MIT License - see LICENSE file for details.

🙏 Acknowledgments

Built with php-mcp/server framework
Based on php-mcp-mysql architecture
Thanks to the MCP community for the protocol specification

💬 Support

Issues: GitHub Issues
Discussions: GitHub Discussions

Version: 1.0.0-beta
Status: Production Testing
Last Updated: January 2025

All versions of php-mcp-postgresql with dependencies

PHP Build Version

Package Version

Version v1.0.2 Release 01. Sep 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of php-mcp-postgresql from vendor momodemo333

Requires php Version >=8.1
php-mcp/server Version ^3.3
ext-pdo Version *
ext-pdo_pgsql Version *

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package momodemo333/php-mcp-postgresql contains the following files

Loading the files please wait ....