PHPackages                             unclecheese/silverstripe-superquery - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. unclecheese/silverstripe-superquery

ActiveSilverstripe-module[Database & ORM](/categories/database)

unclecheese/silverstripe-superquery
===================================

A tool for running queries in the CMS

4252JavaScript

Since Mar 8Pushed 9y ago1 watchersCompare

[ Source](https://github.com/unclecheese/silverstripe-superquery)[ Packagist](https://packagist.org/packages/unclecheese/silverstripe-superquery)[ RSS](/packages/unclecheese-silverstripe-superquery/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

SilverStripe SuperQuery
=======================

[](#silverstripe-superquery)

The power of raw queries, with the elegance of the ORM.

[![](source/images/screenshot.png)](source/images/screenshot.png)

Installation
------------

[](#installation)

`$ composer require unclecheese/sivlerstripe-superquery`

Features
--------

[](#features)

### Run queries from within the CMS using the ORM, or SQL.

[](#run-queries-from-within-the-cms-using-the-orm-or-sql)

Use the `_('YourClassName')` as a replacement for `YourClassName::get()`, and use [Symfony's expression language](http://symfony.com/doc/current/components/expression_language.html) for the rest. (Spoiler: it's so dead simple, you already understand it).

**Examples:**

- `_('File').filter('Created:LessThan', '2015-01-01')`
- `_('Member').filter({'Email:PartialMatch': 'hotmail.com', 'Active': true}).sort('Created DESC')`
- `_('Event').filter('Approved', true).relation('Sponsors').sort('CompanyName ASC')`
- `_('Event').filter('Approved', false).removeAll()`

### Choose which columns you want displayed

[](#choose-which-columns-you-want-displayed)

Click on the `Columns...` button in the footer to bring up a panel allowing you to customise the view.

### Export data to CSV or JSON

[](#export-data-to-csv-or-json)

Click on the export buttons to export the data in its current state in JSON or CSV.

### Save frequently used queries

[](#save-frequently-used-queries)

Click `Save...` to give the query a name and store it in the "saved queries" dropdown.

### Hang it anywhere

[](#hang-it-anywhere)

The API is decoupled from the CMS, meaning the tool can be installed anywhere in your project.

Security
--------

[](#security)

Needless to say, running raw queries against your database is serious business. All actions are restricted to `ADMIN`.

Development
-----------

[](#development)

The tool is built on [ReactJS](https://facebook.github.io/react) using the [Webpack](https://webpack.github.io) module builder. To do dev work:

- Run `npm run start` in the module root directory.
- Visit the `admin/superquery` URL directly in your browser. Navigating to it from with in the CMS will not properly load the dev server.

For realeases / Pull requests:

- Run `npm run build` from the module root directory.

Troubleshooting
---------------

[](#troubleshooting)

Ring Uncle Cheese.

###  Health Score

22

—

LowBetter than 21% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity12

Limited adoption so far

Community5

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/654636?v=4)[Aaron Carlino](/maintainers/unclecheese)[@unclecheese](https://github.com/unclecheese)

### Embed Badge

![Health badge](/badges/unclecheese-silverstripe-superquery/health.svg)

```
[![Health](https://phpackages.com/badges/unclecheese-silverstripe-superquery/health.svg)](https://phpackages.com/packages/unclecheese-silverstripe-superquery)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[pgvector/pgvector

pgvector support for PHP

198628.3k10](/packages/pgvector-pgvector)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)