Offer data browser of indexed data

Created on 9 July 2025, 2 months ago

Problem/Motivation

If you are using Solr, you can always check which data got indexed by going to http://mysite.ddev.site:8983/

This option is not available for Search API standard with MariaDB/MySQL database as backend. The closest is browsing the data with something like PHPMyAdmin, but you need to open each table manually, and it would be much nicer if there was a table, which lists for example ten indexed items.

Steps to reproduce

Want to quickly check if the data got indexed correctly, but don't want to create a View, and add each field manually.

Proposed resolution

Emulate Solr's GUI, by offering a table (a View?) which automatically includes all indexed fields, via the tables such as search_api_db_index_field_example, and presents ten items, grouped by item_id. Fields could be truncated by default to a max length of 255 characters?

Remaining tasks

Feature request
Status

Active

Version

1.0

Component

Miscellaneous

Created by

🇩🇰Denmark ressa Copenhagen

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @ressa
  • 🇦🇹Austria drunken monkey Vienna, Austria

    Thanks for suggesting this feature!

    Since backend plugins in general offer no introspection into the data they have stored I think this functionality would have to be specific to the database backend. Also, due to the denormalized way in which the data is indexed in the database backend, it would take a bit of work to implement this. Therefore, while it certainly seems like it could come handy from time to time, I’ll have to wait until there is either more interest, or I have more time, or someone else steps up and provides an initial MR for this.
    Still, thanks again for the suggestion!

  • 🇩🇰Denmark ressa Copenhagen

    Thanks for the positive approach, I very much appreciate it! And I do agree -- it's more of a "nice to have, than a need to have" -- and since it will take some effort to build, more user interest would probably be great, before spending resources on this.

    I have attempted to expand the issue Summary, based on your feedback, feel of course free to correct anything. Thanks!

  • 🇦🇹Austria drunken monkey Vienna, Austria

    I think we should be able to implement this just using Drupal’s generic database layer, so I don’t think we’ll need to add support for specific DMBSs.
    But otherwise looks good, thanks!

  • 🇩🇰Denmark ressa Copenhagen

    That's fantastic -- it's great how versatile the structure of Drupal is, thanks for the update!

Production build 0.71.5 2024