postgres-mcp

Instructions

Args:
    schema: Schema name (default: public)
    
Returns:
    List of views with name

Implementation Reference

• postgres_mcp/server.py:312-330 (handler)

  MCP tool handler for 'list_views'. Registered via @mcp.tool() decorator. Executes the tool logic by calling PostgresClient.list_views() and formatting the response using ViewSummary models.

  @mcp.tool()
  @handle_db_error
  def list_views(schema: str = "public") -> dict:
      """List all views in a schema.
      
      Args:
          schema: Schema name (default: public)
          
      Returns:
          List of views with name
      """
      client = get_client()
      views = client.list_views(schema)
      
      return {
          "schema": schema,
          "views": [ViewSummary.from_row(v).model_dump() for v in views],
      }

• postgres_mcp/server.py:312-312 (registration)

  The @mcp.tool() decorator registers the list_views function as an MCP tool.

  @mcp.tool()

• postgres_mcp/models.py:157-169 (schema)

  Pydantic BaseModel defining the output schema for view summaries. Used to serialize raw database rows into structured responses.

  class ViewSummary(BaseModel):
      """View info for list responses."""
      
      name: str
      schema_name: str = "public"
      
      @classmethod
      def from_row(cls, row: dict) -> "ViewSummary":
          return cls(
              name=row.get("table_name", ""),
              schema_name=row.get("table_schema", "public"),
          )

• postgres_mcp/postgres_client.py:373-391 (helper)

  Core helper method in PostgresClient that executes the SQL query to retrieve views from information_schema.views.

  def list_views(self, schema: str = "public") -> list[dict]:
      """List views in a schema.
      
      Args:
          schema: Schema name
          
      Returns:
          List of view dicts
      """
      query = """
          SELECT table_name, table_schema
          FROM information_schema.views 
          WHERE table_schema = %s
          ORDER BY table_name
      """
      with self.get_cursor() as cursor:
          cursor.execute(query, (schema,))
          return [dict(row) for row in cursor.fetchall()]