PostgreSQL Server for Model Context Protocol

This is a PostgreSQL server implementation for the Model Context Protocol. It provides a simple interface to interact with PostgreSQL databases.

Installation

npm install

Configuration

Create a configuration object with your PostgreSQL connection details:

const config = {
  host: 'localhost',
  port: 5432,
  database: 'your_database',
  user: 'your_user',
  password: 'your_password',
  ssl: false // optional
};

Usage

import { PostgresServer } from './server';

// Create a new server instance
const server = new PostgresServer(config);

// Test connection
const isConnected = await server.testConnection();
console.log('Connection successful:', isConnected);

// Execute a query
const results = await server.query('SELECT * FROM your_table');
console.log('Query results:', results);

// Close the connection when done
await server.close();

Development

• Build: npm run build
• Test: npm run test
• Lint: npm run lint

License

MIT