PostgreSQL Design Check Queries

Catalog of PostgreSQL queries for finding information about a PostgreSQL database and its design problems

	Choose collection:
AND	Choose query type:
AND	Choose query reliability:
AND	Choose category:
AND	Choose data source:	From where does the query gets its information?
AND	Enter string:
AND	Has fixing queries?

All the queries about database objects contain a subcondition to exclude from the result information about the system catalog.
Although the statements use SQL constructs (common table expressions; NOT in subqueries) that could cause performance problems in case of large datasets it shouldn't be a problem in case of relatively small amount of data, which is in the system catalog of a database.
Statistics about the catalog content and project home in GitHub that has additional information.

There are 961 queries.

Seq nr	Name	Goal▲	Type	Data source	Last update	License	...
481	Name contains only consonants and digits	Find names of database objects that contain only consonants and digits.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-18 16:13	MIT License	View
482	Meaningless terms in names	Find names of database objects that contain terms "foo", "bar", "foobar", or "baz".	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-17 01:07	MIT License	View
483	Name does not contain any vowels	Find names of database objects that do not contain any vowels.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-18 16:14	MIT License	View
484	Names of database objects that end with an underscore	Find names of database objects that end with a underscore.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-17 09:56	MIT License	View
485	Names of database objects with perhaps too many subcomponents (terms) that consist of only consonants	Find names of database objects where the number of subcomponents (terms) that consist of only consonants is bigger than the number of subcomponents that contain at least one vowel.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-18 16:13	MIT License	View
486	Names of database objects with four or more consecutive identical symbols	Find names of database objects with four or more consecutive identical symbols	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-11-11 19:48	MIT License	View
487	Domain CHECK constraint name contains table name	Find names of domain CHECK constraints that contain the name of the base that column the domain specifies. Domains are reusable artifacts that one should be able to use in case of defining different base tables. Thus, it is inappropriate to use the name of a particular table in the name of a domain constraint.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:29	MIT License	View
488	Too short domain constraint names	Find names of domain constraints that are shorter than the length of the name of the domain + two characters.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:29	MIT License	View
489	Domain name contains base table name	Find names of domains that contain the name of the table that column the domain specifies. Domains are reusable artifacts that one should be able to use in case of different base tables. Thus, it is inappropriate to use the name of a particular table in the name of the domain.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:29	MIT License	View
490	Constraints with the same name within the same schema and constraint type	Find names of foreign key constraints that are used within the same schema more than once. Find names of check constraints that are used within the same schema more than once. Find names of constraint triggers that are used within the same schema more than once. Different things should have different names. But here different constraints have the same name. Also make sure that this is not a sign of duplication.	Problem detection	system catalog base tables only	2022-11-15 16:43	MIT License	View
491	Rules with the same name within the same schema	Find names of rules that are used within the same schema more than once. Give different triggers different names.	Problem detection	system catalog base tables only	2021-02-25 17:30	MIT License	View
492	Triggers with the same name within the same schema	Find names of triggers that are used within the same schema more than once. Give different triggers different names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2021-02-25 17:30	MIT License	View
493	Perhaps is not snake_case - Boolean-indicating prefix without underscore	Find names of types, domains, columns, and parameters that perhaps do not use the snake_case naming style because the name starts with "is", "has", or "on" that is not followed by an underscore. Prefer snake_case over PascalCase and camelCase in names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-12-06 11:46	MIT License	View
494	Too generic names (user-defined types, domains)	Find names of user-defined types and domains that contain too generic (noise) words.	Problem detection	system catalog base tables only	2021-10-31 17:41	MIT License	View
495	Extreme contraction	Find names that contain extremely short terms, due to an excessive word contraction, abbreviation, or acronym usage.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-18 16:31	MIT License	View
496	Perhaps is not snake_case - long subsections without underscores	Find names that perhaps do not use the snake_case naming style because the name contains a long subsection (at least 20 characters) without underscores. Prefer snake_case over PascalCase and camelCase in names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-03-18 16:47	MIT License	View
497	Perhaps is not a snake case - date, time, or by is not preceded by an underscore	Find names that perhaps do not use the snake_case naming style because the name ends with the phrase "date", "time", "by" that is not preceded by an underscore. Prefer snake_case over PascalCase and camelCase in names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-12-06 12:12	MIT License	View
498	Perhaps is not snake_case - id, code, key, or nr is not preceded by an underscore	Find names that perhaps do not use the snake_case naming style because the name ends with the phrase "id", "uuid", "code", "kood", "key", or "nr" that is not preceded by an underscore. Prefer snake_case over PascalCase and camelCase in names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-12-31 11:17	MIT License	View
499	Perhaps is not snake_case - id, code, key, or nr is not followed by an underscore	Find names that perhaps do not use the snake_case naming style because the name starts with the phrase "id", "uuid", "code" , "kood", "key", or "nr" that is not followed by an underscore. Prefer snake_case over PascalCase and camelCase in names.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-11-15 17:19	MIT License	View
500	Perhaps an existing domain could be used to define the properties of a base table column?	Find non-foreifgn key base table columns that have not been defined based on a domain but that have the same properties (data type, field size, default value, and pemisson to use NULLs) as some domain. If you define a domain, then you should try to use it in case of multiple columns.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2021-02-25 17:29	MIT License	View