/**
* PostgreSQL MCP Resources
*
* Provides structured data access via URI patterns.
* 20 resources total.
*/
import type { PostgresAdapter } from '../PostgresAdapter.js';
import type { ResourceDefinition } from '../../../types/index.js';
// Core resources
import { createSchemaResource } from './schema.js';
import { createTablesResource } from './tables.js';
import { createSettingsResource } from './settings.js';
import { createStatsResource } from './stats.js';
import { createActivityResource } from './activity.js';
import { createPoolResource } from './pool.js';
// Migrated resources from legacy postgres-mcp-server
import { createCapabilitiesResource } from './capabilities.js';
import { createPerformanceResource } from './performance.js';
import { createHealthResource } from './health.js';
import { createExtensionsResource } from './extensions.js';
import { createIndexesResource } from './indexes.js';
import { createReplicationResource } from './replication.js';
import { createVacuumResource } from './vacuum.js';
import { createLocksResource } from './locks.js';
// Extension status resources
import { createCronResource } from './cron.js';
import { createPartmanResource } from './partman.js';
import { createKcacheResource } from './kcache.js';
import { createVectorResource } from './vector.js';
import { createPostgisResource } from './postgis.js';
import { createCryptoResource } from './crypto.js';
/**
* Get all PostgreSQL resources (20 total)
*
* Core (6):
* - postgres://schema - Full database schema
* - postgres://tables - Table listing with metadata
* - postgres://settings - PostgreSQL configuration
* - postgres://stats - Table/index statistics with stale detection
* - postgres://activity - Active connections and queries
* - postgres://pool - Connection pool statistics
*
* Migrated from legacy server (8):
* - postgres://capabilities - Server version, extensions, tool categories
* - postgres://performance - pg_stat_statements query metrics
* - postgres://health - Comprehensive database health status
* - postgres://extensions - Extension inventory with recommendations
* - postgres://indexes - Index usage with unused detection
* - postgres://replication - Replication status and lag monitoring
* - postgres://vacuum - Vacuum stats and wraparound warnings
* - postgres://locks - Lock contention detection
*
* Extension status (6):
* - postgres://cron - pg_cron job status and history
* - postgres://partman - pg_partman partition configuration
* - postgres://kcache - pg_stat_kcache CPU/I/O metrics
* - postgres://vector - pgvector columns and indexes
* - postgres://postgis - PostGIS spatial columns and indexes
* - postgres://crypto - pgcrypto availability and recommendations
*
*/
export function getPostgresResources(adapter: PostgresAdapter): ResourceDefinition[] {
return [
// Core resources
createSchemaResource(adapter),
createTablesResource(adapter),
createSettingsResource(adapter),
createStatsResource(adapter),
createActivityResource(adapter),
createPoolResource(adapter),
// Migrated resources
createCapabilitiesResource(adapter),
createPerformanceResource(adapter),
createHealthResource(adapter),
createExtensionsResource(adapter),
createIndexesResource(adapter),
createReplicationResource(adapter),
createVacuumResource(adapter),
createLocksResource(adapter),
// Extension status resources
createCronResource(adapter),
createPartmanResource(adapter),
createKcacheResource(adapter),
createVectorResource(adapter),
createPostgisResource(adapter),
createCryptoResource(adapter)
];
}
