Raw JSON report machine-readable
{
"data": {
"repo": {
"topics": [
"query-builder",
"php",
"mysql",
"postgresql",
"microsoft-sql-server",
"sqlite"
],
"is_fork": false,
"size_kb": 1135,
"has_wiki": false,
"homepage": null,
"languages": {
"PHP": 196445
},
"pushed_at": "2026-07-24T21:26:25Z",
"created_at": "2013-09-27T18:08:03Z",
"owner_type": "Organization",
"updated_at": "2026-07-14T14:07:17Z",
"description": "Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "3.x",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "http://auraphp.com",
"name": "Aura for PHP",
"type": "Organization",
"login": "auraphp",
"company": null,
"location": null,
"followers": 63,
"avatar_url": "https://avatars.githubusercontent.com/u/611900?v=4",
"created_at": "2011-02-11T00:05:35Z",
"is_verified": null,
"public_repos": 41,
"account_age_days": 5642
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "2.8.1",
"kind": "patch",
"published_at": "2023-04-25T13:29:38Z"
},
{
"tag": "3.0.0",
"kind": "major",
"published_at": "2023-04-25T13:31:40Z"
},
{
"tag": "2.8.0",
"kind": "minor",
"published_at": "2022-05-21T13:34:40Z"
},
{
"tag": "3.0.0-alpha.1",
"kind": "prerelease",
"published_at": "2022-05-21T12:26:47Z"
},
{
"tag": "2.7.1",
"kind": "patch",
"published_at": "2016-10-03T20:35:38Z"
},
{
"tag": "2.7.0",
"kind": "minor",
"published_at": "2016-09-02T22:10:38Z"
},
{
"tag": "2.6.0",
"kind": "minor",
"published_at": "2015-11-09T15:46:17Z"
},
{
"tag": "2.5.0",
"kind": "minor",
"published_at": "2015-06-02T06:35:28Z"
},
{
"tag": "2.4.2",
"kind": "patch",
"published_at": "2015-03-27T20:09:49Z"
},
{
"tag": "2.4.1",
"kind": "patch",
"published_at": "2015-03-26T04:21:20Z"
},
{
"tag": "2.4.0",
"kind": "minor",
"published_at": "2015-03-22T17:47:37Z"
},
{
"tag": "2.3.0",
"kind": "minor",
"published_at": "2015-03-16T15:06:29Z"
},
{
"tag": "2.2.0",
"kind": "minor",
"published_at": "2015-02-12T20:26:17Z"
},
{
"tag": "2.1.0",
"kind": "minor",
"published_at": "2014-08-24T20:36:49Z"
},
{
"tag": "2.0.0",
"kind": "major",
"published_at": "2014-06-09T16:07:06Z"
},
{
"tag": "2.0.0-beta1",
"kind": "prerelease",
"published_at": "2014-01-07T16:17:44Z"
}
],
"recent_commits": [
{
"oid": "b868202fdf9578d418d5f635b64934ec15e57099",
"body": "Add PHP 8.4 and 8.5 to CI matrix",
"is_bot": false,
"headline": "Merge pull request #212 from koriym/feature/add-php84-85-ci",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2025-12-24T09:52:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e05dd03fbeec50fa69326fc195239a664b795f7d",
"body": "Update LICENSE copyright year to 2025.\nUpdate README to reflect PHP 8.5 support.",
"is_bot": false,
"headline": "Add PHP 8.4 and 8.5 to CI matrix",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2025-12-09T05:24:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b58a7aab3c3291b31671ace4d64cc31e68f3f2a7",
"body": "Updated Github Actions",
"is_bot": false,
"headline": "Merge pull request #210 from rotexdegba/3.x",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2024-03-14T04:50:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d37c20a3cba5834881236951b53b060abd6c6dda",
"body": null,
"is_bot": false,
"headline": "Update QuoterTest.php",
"author_name": "Rotimi Ade",
"author_login": "rotexdegba",
"committed_at": "2024-03-13T19:06:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "85e38a289ac84d7ee9ba3b39843ad00044ec2c6e",
"body": "Made $this->quoter an explicitly defined property to prevent this warning in PHP 8.1+\r\n\r\nPHP Deprecated: Creation of dynamic property Aura\\SqlQuery\\Common\\QuoterTest::$quoter is deprecated in /home/runner/work/Aura.SqlQuery/Aura.SqlQuery/tests/Common/QuoterTest.php on line 10",
"is_bot": false,
"headline": "Update QuoterTest.php",
"author_name": "Rotimi Ade",
"author_login": "rotexdegba",
"committed_at": "2024-03-13T19:05:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11e4fba942be5aa0c04600f0e00caf73b3de0476",
"body": null,
"is_bot": false,
"headline": "Update continuous-integration.yml",
"author_name": "Rotimi Ade",
"author_login": "rotexdegba",
"committed_at": "2024-03-13T18:56:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4113345a126a56da094aebd108f31eab8c89e60c",
"body": null,
"is_bot": false,
"headline": "Update continuous-integration.yml",
"author_name": "Rotimi Ade",
"author_login": "rotexdegba",
"committed_at": "2024-03-13T18:53:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "72ff740f19d8538cd1bdb46f73bc161e8fe88020",
"body": "Update insert.md",
"is_bot": false,
"headline": "Merge pull request #208 from sajjad-rezaei/patch-1",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2023-06-02T10:44:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b92dffbbcb119181a983ef90d77d59b74ddd4185",
"body": "fix closing array bracket",
"is_bot": false,
"headline": "Update insert.md",
"author_name": "Sajjad Rezaei",
"author_login": "sajjad-rezaei",
"committed_at": "2023-06-02T07:20:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6f71a3b82d7018dff437cdd316f3eb851fd3713c",
"body": "It is 100% valid for strripos to return 0\r\nwe want quotes in that case for the AS blah\r\nNEVER EVER if a strripos, always explicitly check for false!!\r\n\r\nThis was breaking jsonb text returns with mixed case aliases\r\n\r\nSelect \"pt\".\"name\"->>'en_US' AS \"myDescription\" from mytable pt is what we want to end up with\r\nThe replaceNamesAndAliasIn was getting ' AS myDescription' and not properly escaping it because the strripos was returning 0",
"is_bot": false,
"headline": "[BUG] Fix bad use of strripos",
"author_name": "Elizabeth M Smith",
"author_login": "auroraeosrose",
"committed_at": "2023-04-25T13:21:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "265abd3e84d2715b1bcaa23e08b725213b77ba9b",
"body": "Enable PHP 8.2 compat",
"is_bot": false,
"headline": "Merge pull request #204 from koriym/php8.2_support",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-12-12T05:15:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ded1fb4009fdff0c918d279d32cc6cc72534cff3",
"body": null,
"is_bot": false,
"headline": "Refactor gitHub actions deprecated command",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-12-11T23:28:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "67f891ec66d36f2999e70636ad21a51ef64a9c75",
"body": null,
"is_bot": false,
"headline": "Test with PHP 8.2",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-12-11T04:09:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "261d64d7c515779378047027c3c4a1cdbf512472",
"body": null,
"is_bot": false,
"headline": "Update .gitignore",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-12-11T04:06:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "265066022f34cd03a883aaac8be2524a8b707602",
"body": "Specify composer version to run up to PHP 7.1 with CI",
"is_bot": false,
"headline": "Merge pull request #202 from koriym/run_ci_on_php_71",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-05-11T12:21:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d14144dff8f07e1c2836fdc19f7ac5e375237157",
"body": null,
"is_bot": false,
"headline": "Specify composer version to support PHP7.0/7.1",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-05-11T10:59:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b3c1945c57f0293a63596d646fe2e2a7e8426e9",
"body": "Fix deprecated test method",
"is_bot": false,
"headline": "Merge pull request #199 from koriym/fix-test",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-04T16:05:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4c99b8cd6a2710a79ccb77d55e798c87b81670ec",
"body": null,
"is_bot": false,
"headline": "Fix deprecated test method",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-04T15:06:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b6a0a49570483557c3171bd1c2df75e1fa2acaf0",
"body": "…rface\n\nAdd ignore() method to common Insert class",
"is_bot": false,
"headline": "Merge pull request #173 from maximTarleckiy/add-ignore-to-common-inte…",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-04T09:51:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "84b0a180e3850ab5c49cf2f0c9d702c1a795c46d",
"body": "Refactor #162",
"is_bot": false,
"headline": "Merge pull request #198 from koriym/inline_array",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-04T08:23:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a2cee5be26fc43fbde84d6120f8417bf72a8420f",
"body": "Support inline array for condition",
"is_bot": false,
"headline": "Merge pull request #162 from syrm/3.x",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-04T08:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d5d78ebc0dec1efc9f41047090b350d3ff6ff6d5",
"body": null,
"is_bot": false,
"headline": "Add .gitattributes",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-04T07:11:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e5af1ed73cfebd2e39b5c71942ad252073a8820b",
"body": null,
"is_bot": false,
"headline": "Add codecov.yml",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-04T07:07:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "66333facc3ec34cb16e75676798567c9f9af48c6",
"body": null,
"is_bot": false,
"headline": "Extract getCond method",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-04T06:41:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "091f470e6d8ebbaafd978a7984b231a4f8279ecc",
"body": "Fix types in phpdoc",
"is_bot": false,
"headline": "Merge pull request #197 from koriym/fix_type",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-04T04:12:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02fbe59cf348d28e8d9a0b09f2c67355524dfd7a",
"body": "…for-sqlite-extension\n\nAdd to composer ext-pdo_sqlite which required for tests",
"is_bot": false,
"headline": "Merge pull request #174 from maximTarleckiy/add-composer-requirement-…",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-03T18:00:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fa9a3964f85bff5462691071e1d30a8f51a3cc7b",
"body": null,
"is_bot": false,
"headline": "Fixing merge conflicts made a invalid json.",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-03T17:59:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2424e1dff476936df4541629c2d6b57e328f2bd6",
"body": null,
"is_bot": false,
"headline": "Merge branch '3.x' into add-composer-requirement-for-sqlite-extension",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-03T17:57:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb54a9ccd30a654bf400d329a58ba006cfae8011",
"body": null,
"is_bot": false,
"headline": "Fix parameter name mismatch with interface",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T16:39:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "920cffb903cd9a5c12605618744e435a38b6eaa4",
"body": null,
"is_bot": false,
"headline": "Fix types in phpdoc",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T16:38:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2c8161282fe08d3f5926c901eb47aaa5cac9995",
"body": "Fix typos",
"is_bot": false,
"headline": "Merge pull request #196 from koriym/fix_typos",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-03T16:01:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e94d118e4cd3cfdcf8048b8744bc909523680e94",
"body": "Enable PHP 5.6-8.1 compat in 3.x",
"is_bot": false,
"headline": "Merge pull request #195 from koriym/gh_action",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2022-02-03T15:59:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4c91edc134f6c54887863893ae7321d1b6430110",
"body": null,
"is_bot": false,
"headline": "Fix typos",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T15:32:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "449c001c04f4565253426caa729e13d62fda0d19",
"body": null,
"is_bot": false,
"headline": "fixup! Enable PHP5.6-8.1 compat",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T15:17:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "44281c900ebb96e4e7272b76cdff28d90f95ff65",
"body": null,
"is_bot": false,
"headline": "Update phpunit.xml.dist",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T15:05:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c0b6e12cbe174a5728b5bd038dc27499693f6165",
"body": null,
"is_bot": false,
"headline": "Update CI badges",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T15:05:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "12682d99ae22f5c1a8458bb845c07f4484099077",
"body": null,
"is_bot": false,
"headline": "Update copy-right year",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:58:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6989b41b9a0aed59063a1f4e50d882fc6e343c0b",
"body": null,
"is_bot": false,
"headline": "Update .scrutinizer.yml",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:58:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2553535a1aaba4a22789d159115265cbe7d28f56",
"body": null,
"is_bot": false,
"headline": "Remove .travis.yml",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:57:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2aa7ea6704bd5700b8075a5fc1489300e3e219fc",
"body": null,
"is_bot": false,
"headline": "Upload test coverage report to codecov",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:57:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8d9fd96346ea032a102444d8400c5886a0aa7c8",
"body": null,
"is_bot": false,
"headline": "Add php5.6-7.1 test",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:54:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e4c91a5bdfddda10dcbecfd5c1fce10727fa0aa8",
"body": null,
"is_bot": false,
"headline": "Adding GitHub Actions.",
"author_name": "Brandon Savage",
"author_login": "brandonsavage",
"committed_at": "2022-02-03T14:52:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ccf7cfea6077ca62403828a6ff5a9d5693b28cec",
"body": null,
"is_bot": false,
"headline": "Enable PHP5.6-8.1 compat",
"author_name": "Akihito Koriyama",
"author_login": "koriym",
"committed_at": "2022-02-03T14:50:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4697be9a913e285c1234c68cd135095807d33fdd",
"body": "fixes #178",
"is_bot": false,
"headline": "Merge pull request #179 from auraphp/issue-178",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2021-03-12T14:10:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5e54a0993061bd4202b963684ed4795c6a9c6ae4",
"body": "minor typo in select.md",
"is_bot": false,
"headline": "Merge pull request #182 from cameronsteele/patch-3",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2021-03-10T15:54:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "30c170ca6e24d46f957a86fcd0b2d3fd42458469",
"body": "improve select.md orderBy example",
"is_bot": false,
"headline": "Merge pull request #181 from cameronsteele/patch-2",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2021-03-10T15:54:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cff9d5b7c2bb99f5549bfdaab3402dacd4c596de",
"body": "fix minor typo in instantiation.md",
"is_bot": false,
"headline": "Merge pull request #180 from cameronsteele/patch-1",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2021-03-10T15:53:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6fbd91aceffbd3402406d87f9d07a97367af7eb8",
"body": null,
"is_bot": false,
"headline": "minor typo in select.md",
"author_name": "Cameron Steele",
"author_login": "cammytown",
"committed_at": "2021-03-10T09:06:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bbd26aa5d25ab15e786871808926eb91b3778e40",
"body": "Demonstrate usage of order method.",
"is_bot": false,
"headline": "improve select.md orderBy example",
"author_name": "Cameron Steele",
"author_login": "cammytown",
"committed_at": "2021-03-10T07:55:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "21df6d1eb152713b80a79152e7ff64a338a8c913",
"body": null,
"is_bot": false,
"headline": "minor typo in instantiation.md",
"author_name": "Cameron Steele",
"author_login": "cammytown",
"committed_at": "2021-03-10T07:17:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f9e91ee8b9351b1de36483070f5d2efa4efb3e86",
"body": null,
"is_bot": false,
"headline": "fixes #178",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2021-03-02T21:42:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "513747a1b399b910f6050e78bd64c3c125a81abf",
"body": "Explain how to bind IN conditions",
"is_bot": false,
"headline": "Merge pull request #175 from afilina/patch-1",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2020-02-17T16:40:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e3c44e0a9b765de8bfc952360efd5d93c36d09c4",
"body": null,
"is_bot": false,
"headline": "Explain how to bind IN conditions",
"author_name": "Anna Filina",
"author_login": "afilina",
"committed_at": "2020-02-16T21:17:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e98101f7390c01675913928986d2099a438927b",
"body": null,
"is_bot": false,
"headline": "Add to composer ext-pdo_sqlite which required for tests",
"author_name": "Maksims Tarleckis",
"author_login": null,
"committed_at": "2020-01-16T12:46:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "020bad71def1bf4bc4fc0a7bbd319124093a2f08",
"body": null,
"is_bot": false,
"headline": "Add ignore() method to common Insert class",
"author_name": "Maksims Tarleckis",
"author_login": null,
"committed_at": "2020-01-16T12:32:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8049fc6bcbe75a8196aa04af6a19ae79dfa75370",
"body": "Test newer PHP versions on CI",
"is_bot": false,
"headline": "Merge pull request #169 from Bilge/patch-1",
"author_name": "Paul M. Jones",
"author_login": "pmjones",
"committed_at": "2020-01-02T03:17:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9bf6273111e2d3695a6959997812f661154ef80a",
"body": null,
"is_bot": false,
"headline": "Test newer PHP versions on CI",
"author_name": "Bilge",
"author_login": "Bilge",
"committed_at": "2020-01-01T14:40:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "40a430ebe8ca6b897cd65bcd9c78f9b80d93fcaa",
"body": null,
"is_bot": false,
"headline": "Support inline array for condition",
"author_name": "Sylvain Robez-Masson",
"author_login": null,
"committed_at": "2018-04-03T09:33:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a4fd8dc4493d517ef3d06e1dbb9433c81fff16ce",
"body": "Drop HHVM support v3.x",
"is_bot": false,
"headline": "Merge pull request #153 from odan/3.x",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2017-11-29T17:43:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6000e9f6767d5b757ce1e74f1233e6fa7ba24727",
"body": "Make travis use trusty",
"is_bot": false,
"headline": "Merge pull request #148 from jakejohns/hotfix/travis",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2017-11-29T17:41:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0c41f46df863ecc0bb90c7f7b0ed59606fa0e5dc",
"body": null,
"is_bot": false,
"headline": "Drop HHVM support #147",
"author_name": "Daniel Opitz",
"author_login": "odan",
"committed_at": "2017-11-29T12:22:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b252c11e06ae1c7b3e37a2a7a6105d777191e7a",
"body": null,
"is_bot": false,
"headline": "Add php 7.1 to travis conf",
"author_name": "jake johns",
"author_login": "jakejohns",
"committed_at": "2017-10-24T16:01:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c7fb0b2192991e6855981a4bc86a4e77f4b58c0",
"body": null,
"is_bot": false,
"headline": "Make travis use trusty",
"author_name": "jake johns",
"author_login": "jakejohns",
"committed_at": "2017-07-21T23:58:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "605548ca0a1eb08327807bec49d49cc206e91651",
"body": "Add missing closing ``` in docs/select.md",
"is_bot": false,
"headline": "Merge pull request #144 from johnchen902/patch-1",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-06-03T15:40:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "65a315f648adc2ab7c35270b7804529ef10da755",
"body": null,
"is_bot": false,
"headline": "Add missing closing ``` in docs/select.md",
"author_name": "John Chen",
"author_login": "johnchen902",
"committed_at": "2017-06-03T11:26:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b1bcd35f21e1c63c743b9f60877b364be79d56b3",
"body": null,
"is_bot": false,
"headline": "Merge branch '3.x' of github.com:auraphp/Aura.SqlQuery into 3.x",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-19T14:50:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "052e05453251dae4d7c830be80b1aca3b674f23f",
"body": null,
"is_bot": false,
"headline": "continue updating docs",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-19T14:50:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cd93d4272bdd31d7d7c2ab55cd68260afe2c4549",
"body": "Add \"table dot star\" assertion to quoter test",
"is_bot": false,
"headline": "Merge pull request #140 from djmattyg007/add_quotertest_assertion",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-19T14:48:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f38d290b3d667b8308dad40fe98bf02c16f60412",
"body": "Only fall back to common quoter when DB-specific quoter doesn't exist",
"is_bot": false,
"headline": "Merge pull request #141 from djmattyg007/fix_quoter_instantiation",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-18T15:48:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a26ae17c0c3442b8f6847397b4939d01fb154c6b",
"body": null,
"is_bot": false,
"headline": "Only fall back to common quoter when DB-specific quoter doesn't exist",
"author_name": "Matthew Gamble",
"author_login": "djmattyg007",
"committed_at": "2017-04-18T03:58:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d15014960f2998853ce88270296434082eed55db",
"body": null,
"is_bot": false,
"headline": "Add \"table dot star\" assertion to quoter test",
"author_name": "Matthew Gamble",
"author_login": "djmattyg007",
"committed_at": "2017-04-16T01:51:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "485d31b32c5940174558387c38054ea457acbc38",
"body": null,
"is_bot": false,
"headline": "update docblocks",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T21:58:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "eb25b93c4ff02e8a6076820e9f171dabbcfab107",
"body": null,
"is_bot": false,
"headline": "update docblocks",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T21:58:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0a3e42bef7f64f814a287317824c1b687a13fbcd",
"body": null,
"is_bot": false,
"headline": "update docblocks",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T20:08:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3318bdf6d112d524d820e63d795466d0041c7e5b",
"body": null,
"is_bot": false,
"headline": "use MIT license",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T19:06:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fe9785340bc8ba344fb41e94eebfaa6af64ae7fc",
"body": null,
"is_bot": false,
"headline": "use vendor phpunit",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T19:06:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bda66e1ef383fc0b6aa5db8ddac3d61cf68b7624",
"body": null,
"is_bot": false,
"headline": "update composer metadata",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T19:06:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2035782bd601f995fe00b23e2e107db0a8aefbb3",
"body": null,
"is_bot": false,
"headline": "update docs",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T19:00:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fa5e79deafb44ee08dd869dbab751339184f4cc3",
"body": null,
"is_bot": false,
"headline": "update license years",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-04-14T19:00:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "713ad5c9d6b83cc5b7db8adf86ee377ca3a06032",
"body": null,
"is_bot": false,
"headline": "remove php tags from docs",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T19:53:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dd21e32eea37a77763c62df263261424139d7f06",
"body": "Support 'grouping' of where() and having() conditions",
"is_bot": false,
"headline": "Merge pull request #136 from auraphp/3.x-parens-around-conditions",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T19:37:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "10ec2f08e3de156a0c0f4f33f89957714bc7fcbc",
"body": null,
"is_bot": false,
"headline": "add having() closure test",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T17:18:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b5ecf257525de240bf5bea720eb5578646f02d06",
"body": "This allows for where(function($select){...}), and put parens around the resulting conditions",
"is_bot": false,
"headline": "support 'grouping' of where() and having() conditions",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T16:53:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "def68e2037ebf0858acaa250b5be97008aa05a48",
"body": null,
"is_bot": false,
"headline": "Merge branch '3.x' of github.com:auraphp/Aura.SqlQuery into 3.x",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T15:57:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7ad42c67e392171a460c899689f9b5826fc32d9f",
"body": null,
"is_bot": false,
"headline": "docblock",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T15:57:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3d57c42bb728a7292f5f30a458c5e71a0c13008f",
"body": "Fixes #125",
"is_bot": false,
"headline": "Merge pull request #135 from auraphp/harikt-patch-1",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T15:55:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8e06753e76b7ea385fba7332577d92af95efe8fa",
"body": null,
"is_bot": false,
"headline": "Fixes #125",
"author_name": "Hari K T",
"author_login": "harikt",
"committed_at": "2017-03-22T15:55:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "98a986d06091ae7f1156be766b7afdc9c6181e6e",
"body": "3.x: Named placeholders only for where() et al. conditions",
"is_bot": false,
"headline": "Merge pull request #134 from auraphp/3.x-named-placeholders-only",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T14:28:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0328669f9d4f49003db5e8cf5868f094c04083c6",
"body": null,
"is_bot": false,
"headline": "use SelectInterface, not SubSelectInterface",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T14:15:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3be4c853ce5337d40c772f2b80bbaea460fd2f9f",
"body": "Remove SubSelect interface, typehint on SelectInterface instead",
"is_bot": false,
"headline": "Merge pull request #133 from auraphp/3.x-subselect-interface",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-22T14:12:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b69470237a01865d2260532d4a3ac438cd164a7c",
"body": null,
"is_bot": false,
"headline": "clean up diff",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T21:05:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "93047d3d3af21530ff2126babf4645eaaeab2e10",
"body": null,
"is_bot": false,
"headline": "no more need to track instance counts now that seq prefixes are not used",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T21:03:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b88cbedee47e8e9eedf5d7cd8a58b2e3bc5b6553",
"body": null,
"is_bot": false,
"headline": "whitespace",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T21:01:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "33ccf7af7e094592ff5c06e41f23f9edea236b6f",
"body": null,
"is_bot": false,
"headline": "remove seq-bind prefixing methods",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:59:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4af5995ebff4637223550d1398f26e64a029c533",
"body": null,
"is_bot": false,
"headline": "in tests, change :_?_ to :named placeholder",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:51:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bc794818a6c09bc84ba585c934b17bff4af0b057",
"body": null,
"is_bot": false,
"headline": "add back subselects as join conditions",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:42:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "913a85ebf7bf05e91cc7b7a01717d966737a3b4a",
"body": null,
"is_bot": false,
"headline": "join*() now support only named binding",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:22:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8920d820f05d515f2ff68558a3b7126550464bbe",
"body": null,
"is_bot": false,
"headline": "move method to only place it is used",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:11:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6a3d98e2bb6a4f790b130aa2ed033dde2814434b",
"body": null,
"is_bot": false,
"headline": "where() and having() now support only named binding",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T20:07:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fcb764c45569ba11fb1b816d804805ac2b1db0f4",
"body": null,
"is_bot": false,
"headline": "remove addWhere() in favor of addClauseCondWithBind()",
"author_name": "Paul M. Jones",
"author_login": null,
"committed_at": "2017-03-21T19:26:44Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 16,
"commits_last_year": 2,
"latest_release_at": "2023-04-25T13:29:38Z",
"latest_release_tag": "2.8.1",
"releases_from_tags": false,
"days_since_last_push": 0,
"active_weeks_last_year": 2,
"days_since_latest_release": 1186,
"mean_days_between_releases": 328
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": true,
"health_percentage": 50,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "aura/sqlquery",
"exists": true,
"license": "MIT",
"keywords": [
"database",
"sql",
"db",
"mysql",
"sqlite",
"postgresql",
"query",
"pdo",
"pgsql",
"postgres",
"sql server",
"sqlserver",
"update",
"insert",
"select",
"delete",
"dml"
],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/aura/sqlquery",
"is_deprecated": false,
"latest_version": "3.0.0",
"repository_url": "https://github.com/auraphp/Aura.SqlQuery",
"versions_count": 16,
"total_downloads": 3166534,
"dependents_count": 43,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 58482,
"first_published_at": null,
"latest_published_at": "2023-04-25T13:21:16Z",
"latest_version_yanked": null,
"days_since_latest_publish": 1186
}
]
},
"popularity": {
"forks": 87,
"stars": 456,
"watchers": 32,
"fork_history": {
"days": [
{
"date": "2013-10-03",
"count": 1
},
{
"date": "2014-01-28",
"count": 1
},
{
"date": "2014-02-21",
"count": 1
},
{
"date": "2014-06-26",
"count": 1
},
{
"date": "2014-07-02",
"count": 1
},
{
"date": "2014-08-05",
"count": 1
},
{
"date": "2014-10-14",
"count": 1
},
{
"date": "2014-12-03",
"count": 1
},
{
"date": "2015-02-04",
"count": 1
},
{
"date": "2015-02-05",
"count": 2
},
{
"date": "2015-03-06",
"count": 1
},
{
"date": "2015-03-17",
"count": 3
},
{
"date": "2015-03-19",
"count": 2
},
{
"date": "2015-03-24",
"count": 1
},
{
"date": "2015-04-07",
"count": 1
},
{
"date": "2015-04-21",
"count": 1
},
{
"date": "2015-05-15",
"count": 1
},
{
"date": "2015-08-27",
"count": 1
},
{
"date": "2015-08-31",
"count": 1
},
{
"date": "2015-09-09",
"count": 1
},
{
"date": "2015-09-14",
"count": 1
},
{
"date": "2015-10-20",
"count": 1
},
{
"date": "2015-10-31",
"count": 1
},
{
"date": "2015-12-10",
"count": 1
},
{
"date": "2016-01-13",
"count": 1
},
{
"date": "2016-04-21",
"count": 1
},
{
"date": "2016-05-07",
"count": 1
},
{
"date": "2016-05-18",
"count": 1
},
{
"date": "2016-05-23",
"count": 1
},
{
"date": "2016-06-13",
"count": 1
},
{
"date": "2016-08-08",
"count": 1
},
{
"date": "2016-10-12",
"count": 1
},
{
"date": "2016-10-28",
"count": 1
},
{
"date": "2017-01-21",
"count": 1
},
{
"date": "2017-02-20",
"count": 1
},
{
"date": "2017-04-16",
"count": 1
},
{
"date": "2017-07-17",
"count": 1
},
{
"date": "2017-07-21",
"count": 1
},
{
"date": "2017-10-19",
"count": 1
},
{
"date": "2018-02-07",
"count": 1
},
{
"date": "2018-02-24",
"count": 1
},
{
"date": "2018-03-22",
"count": 1
},
{
"date": "2018-04-02",
"count": 1
},
{
"date": "2018-05-02",
"count": 1
},
{
"date": "2018-05-18",
"count": 1
},
{
"date": "2018-05-30",
"count": 1
},
{
"date": "2018-09-21",
"count": 1
},
{
"date": "2018-11-10",
"count": 1
},
{
"date": "2018-12-13",
"count": 1
},
{
"date": "2019-01-21",
"count": 1
},
{
"date": "2019-03-21",
"count": 1
},
{
"date": "2019-07-06",
"count": 1
},
{
"date": "2019-07-19",
"count": 1
},
{
"date": "2019-09-06",
"count": 1
},
{
"date": "2019-11-11",
"count": 1
},
{
"date": "2020-01-01",
"count": 1
},
{
"date": "2020-01-16",
"count": 1
},
{
"date": "2020-02-16",
"count": 1
},
{
"date": "2020-03-21",
"count": 1
},
{
"date": "2020-04-08",
"count": 1
},
{
"date": "2020-11-19",
"count": 1
},
{
"date": "2021-03-10",
"count": 1
},
{
"date": "2021-05-02",
"count": 1
},
{
"date": "2021-06-26",
"count": 1
},
{
"date": "2021-09-21",
"count": 1
},
{
"date": "2021-10-27",
"count": 1
},
{
"date": "2022-01-05",
"count": 1
},
{
"date": "2022-01-07",
"count": 1
},
{
"date": "2022-01-27",
"count": 1
},
{
"date": "2022-10-02",
"count": 1
},
{
"date": "2023-06-02",
"count": 1
},
{
"date": "2023-10-31",
"count": 1
},
{
"date": "2024-03-13",
"count": 1
},
{
"date": "2024-06-16",
"count": 1
},
{
"date": "2024-06-23",
"count": 1
},
{
"date": "2024-09-25",
"count": 1
},
{
"date": "2024-09-26",
"count": 2
},
{
"date": "2024-12-12",
"count": 1
}
],
"complete": true,
"collected": 83,
"total_forks": 87
},
"star_history": null,
"open_issues_and_prs": 25
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 30633,
"source_files_sampled": 79,
"oversized_source_files": 0,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies carried a version and a supported ecosystem",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 3,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "ext-pdo_sqlite",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "php",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "yoast/phpunit-polyfills",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 3,
"direct_count": 0,
"indirect_count": 3
}
},
"maintainership": {
"issues": {
"open_prs": 3,
"merged_prs": 94,
"open_issues": 22,
"closed_ratio": 0.776,
"closed_issues": 76,
"closed_unmerged_prs": 17
},
"bus_factor": 3,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "harikt",
"commits": 52,
"avatar_url": "https://avatars.githubusercontent.com/u/120454?v=4"
},
{
"type": "User",
"login": "MAXakaWIZARD",
"commits": 31,
"avatar_url": "https://avatars.githubusercontent.com/u/1138453?v=4"
},
{
"type": "User",
"login": "koriym",
"commits": 27,
"avatar_url": "https://avatars.githubusercontent.com/u/529021?v=4"
},
{
"type": "User",
"login": "pavarnos",
"commits": 20,
"avatar_url": "https://avatars.githubusercontent.com/u/589595?v=4"
},
{
"type": "User",
"login": "mindplay-dk",
"commits": 12,
"avatar_url": "https://avatars.githubusercontent.com/u/103348?v=4"
},
{
"type": "User",
"login": "kornrunner",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/725986?v=4"
},
{
"type": "User",
"login": "pmjones",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/25754?v=4"
},
{
"type": "User",
"login": "rotexdegba",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/1242622?v=4"
},
{
"type": "User",
"login": "nyamsprod",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/51073?v=4"
},
{
"type": "User",
"login": "cammytown",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/735509?v=4"
}
],
"contributors_sampled": 36,
"top_contributor_share": 0.259
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"continuous-integration.yml"
],
"has_docs_dir": true,
"linter_configs": [],
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": null,
"reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 0,
"reason": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 9,
"reason": "Found 11/12 approved changesets -- score normalized to 9",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 12 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 0,
"reason": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 0,
"reason": "detected GitHub workflow tokens with excessive permissions",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "b868202fdf9578d418d5f635b64934ec15e57099",
"ran_at": "2026-07-24T21:33:10Z",
"aggregate_score": 4.3,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-24T21:27:14Z",
"oldest_open_prs": [
{
"number": 142,
"created_at": "2017-04-19T21:14:20Z",
"last_comment_at": "2022-02-04T13:47:31Z",
"last_comment_author": "pmjones"
},
{
"number": 165,
"created_at": "2018-05-02T14:22:55Z",
"last_comment_at": "2018-05-02T14:50:14Z",
"last_comment_author": "dc2xl"
},
{
"number": 184,
"created_at": "2021-05-02T10:23:51Z",
"last_comment_at": "2021-06-02T06:56:30Z",
"last_comment_author": "golgote"
}
],
"last_merged_pr_at": "2025-12-24T09:52:37Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": [
{
"number": 104,
"created_at": "2016-09-03T21:27:17Z",
"last_comment_at": "2017-03-22T14:44:02Z",
"last_comment_author": "pmjones"
},
{
"number": 124,
"created_at": "2017-01-24T15:13:00Z",
"last_comment_at": "2017-03-22T15:50:16Z",
"last_comment_author": "pavarnos"
},
{
"number": 130,
"created_at": "2017-03-06T10:42:05Z",
"last_comment_at": "2017-03-11T15:27:34Z",
"last_comment_author": "pmjones"
},
{
"number": 139,
"created_at": "2017-04-16T01:48:32Z",
"last_comment_at": "2017-04-20T18:16:45Z",
"last_comment_author": "harikt"
},
{
"number": 143,
"created_at": "2017-05-22T11:52:04Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 149,
"created_at": "2017-07-25T12:43:50Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 151,
"created_at": "2017-09-14T09:48:30Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 155,
"created_at": "2017-12-06T15:25:21Z",
"last_comment_at": "2021-05-02T10:52:46Z",
"last_comment_author": "golgote"
},
{
"number": 157,
"created_at": "2018-02-01T18:59:16Z",
"last_comment_at": "2022-05-21T12:17:16Z",
"last_comment_author": "harikt"
},
{
"number": 158,
"created_at": "2018-02-26T18:21:29Z",
"last_comment_at": "2018-02-28T21:57:15Z",
"last_comment_author": "designermonkey"
},
{
"number": 160,
"created_at": "2018-03-07T18:22:05Z",
"last_comment_at": "2018-03-08T13:05:01Z",
"last_comment_author": "pmjones"
},
{
"number": 161,
"created_at": "2018-03-21T15:40:14Z",
"last_comment_at": "2020-10-21T16:24:00Z",
"last_comment_author": "jimbo8098"
},
{
"number": 164,
"created_at": "2018-04-24T14:47:49Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 171,
"created_at": "2020-01-10T06:54:05Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 172,
"created_at": "2020-01-13T14:29:34Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 176,
"created_at": "2020-02-22T12:44:38Z",
"last_comment_at": "2020-10-20T21:00:09Z",
"last_comment_author": "jimbo8098"
},
{
"number": 177,
"created_at": "2020-05-28T17:10:13Z",
"last_comment_at": "2020-05-28T18:45:04Z",
"last_comment_author": "otelconsulting"
},
{
"number": 183,
"created_at": "2021-03-24T15:10:32Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 189,
"created_at": "2021-09-01T20:20:50Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 192,
"created_at": "2022-01-04T12:58:07Z",
"last_comment_at": "2024-04-24T16:29:21Z",
"last_comment_author": "anoxia"
}
]
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/auraphp/Aura.SqlQuery",
"host": "github.com",
"name": "Aura.SqlQuery",
"owner": "auraphp"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 58,
"inputs": {
"security": 43,
"vitality": 43,
"community": 70,
"governance": 74,
"engineering": 59
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "at_risk",
"name": "Vitality",
"value": 43,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "at_risk",
"name": "Development activity",
"note": null,
"notes": [],
"value": 42,
"inputs": {
"commits_last_year": 2,
"human_commit_share": 1,
"days_since_last_push": 0,
"active_weeks_last_year": 2
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 0 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "push_recency",
"params": {
"days": 0
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "2/52 weeks with commits",
"points": 1.4,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 2
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "2 commits in the last year",
"points": 4.3,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 2
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "at_risk",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 44,
"inputs": {
"releases_count": 16,
"latest_release_tag": "2.8.1",
"releases_from_tags": false,
"days_since_latest_release": 1186,
"mean_days_between_releases": 328
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "16 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 16
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 1186 days ago",
"points": 0,
"status": "missed",
"details": [
{
"code": "release_recency",
"params": {
"days": 1186
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~328 days",
"points": 12.6,
"status": "partial",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 328
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "dormant",
"guards": [],
"signals": [
"issue_rot",
"scorecard_unmaintained"
],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": 3,
"unanswered_open_issues": 14,
"days_since_last_merged_pr": 212,
"days_since_last_human_commit": 212,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "no human commit for 212 days, with nothing left unanswered",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_quiet",
"params": {
"days": 212
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "good",
"name": "Community & Adoption",
"value": 70,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "moderate",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 68,
"inputs": {
"forks": 87,
"stars": 456,
"watchers": 32,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "456 stars",
"points": 43.1,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 456
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "87 forks",
"points": 16.1,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 87
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "32 watchers",
"points": 8.3,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 32
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "good",
"name": "Community health",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 18,
"status": "met",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "good",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 75,
"inputs": {
"packages": [
"aura/sqlquery"
],
"dependents": 43,
"ecosystems": "packagist",
"total_downloads": 3166534,
"monthly_downloads": 58482
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "58,482 downloads/month across packagist",
"points": 63.6,
"status": "partial",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 58482,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "43 packages depend on it",
"points": 11,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 43
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "good",
"name": "Sustainability & Governance",
"value": 74,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "good",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 76,
"inputs": {
"bus_factor": 3,
"contributors_sampled": 36,
"top_contributor_share": 0.259
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "3 contributor(s) cover half of all commits",
"points": 36,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 3
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 26% of commits",
"points": 16.7,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 26
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "36 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 36
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 12 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "good",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 82,
"inputs": {
"merged_prs": 94,
"open_issues": 22,
"closed_issues": 76,
"issue_closed_ratio": 0.776,
"closed_unmerged_prs": 17
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "78% of issues closed",
"points": 36.3,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 78
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "94/111 decided PRs merged",
"points": 32.4,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 94,
"decided": 111
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 11/12 approved changesets -- score normalized to 9",
"points": 13.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "moderate",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 67,
"inputs": {
"followers": 63,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "auraphp",
"public_repos": 41,
"account_age_days": 5642
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "63 followers of auraphp",
"points": 13,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 63,
"login": "auraphp"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "41 public repos, account ~15 yr old",
"points": 23.8,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 41
}
},
{
"code": "account_age_years",
"params": {
"years": 15
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "moderate",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 69,
"inputs": {
"packages": [
"aura/sqlquery"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 1186
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on packagist",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "packagist"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 1186 days ago",
"points": 4,
"status": "partial",
"details": [
{
"code": "publish_recency",
"params": {
"days": 1186
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "16 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 16
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "moderate",
"name": "Engineering Quality",
"value": 59,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "at_risk",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 48,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "good",
"name": "Documentation",
"note": null,
"notes": [],
"value": 75,
"inputs": {
"topics": [
"query-builder",
"php",
"mysql",
"postgresql",
"microsoft-sql-server",
"sqlite"
],
"has_wiki": false,
"homepage": null,
"has_readme": true,
"has_docs_dir": true,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 25,
"status": "met",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "6 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 6
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 43,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"branch_protection",
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 43,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 15,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 3,
"scorecard_aggregate": 4.3
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 11/12 approved changesets -- score normalized to 9",
"points": 6.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 12 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "detected GitHub workflow tokens with excessive permissions",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 18
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "critical",
"name": "AI Readiness",
"value": 27,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 19,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.35,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "no CLAUDE.md / AGENTS.md / editor rules",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_instructions",
"params": {}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "35 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 18.7,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 35,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "critical",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 22,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 100",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 30633,
"source_files_sampled": 79,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "PHP without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "PHP"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/79 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 79,
"oversized": 0
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-24T21:33:37.408801Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/auraphp/Aura.SqlQuery.svg",
"full_name": "auraphp/Aura.SqlQuery",
"license_state": "standard",
"license_spdx": "MIT"
}