excalibur_list_posts

io.github.lonniev/excalibur-mcp · Verify this server

List your stored posts, server-side sorted, filtered, and offset-paginated. Optional ``status`` filter — a single status or a comma-separated set (e.g. ``draft,scheduled``), matched as set membership. ``sort_col`` is one of ``created|updated|status|scheduled`` (default ``created``); ``sort_dir`` is ``asc|desc``. ``search`` is a case-insensitive regular expression matched against the post text. ``date_from``/``date_to`` accept bare ``YYYY-MM-DD`` (UTC-calendar day, end-inclusive) or an ISO instant (patron-local midnight from the FE — exclusive upper bound when instant). Bound the ``date_field`` column, one of ``created|updated|scheduled|sent`` (default ``created``). ``template_id`` filters to the sent occurrences a recurring template fired. ``sent_hour`` (0–23) with ``time_zone`` (IANA) keeps only posts whose ``last_sent_at`` local wall hour in that zone matches — used by the Performance time-of-day chart deep-link. ``page`` is 0-indexed; ``page_size`` is 1..100. Each row carries ``is_recurring``, ``has_dynamic``, and ``template_id`` (set on sent occurrences). Returns ``{posts:[…], total, page, page_size}`` reflecting the filtered set.